CRM/Contact/Page/AJAX.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | CiviCRM version 4.4                                                |
   5  +--------------------------------------------------------------------+
   6  | Copyright CiviCRM LLC (c) 2004-2013                                |
   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 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  +--------------------------------------------------------------------+
  26 */
  27
  28 /**
  29  *
  30  * @package CRM
  31  * @copyright CiviCRM LLC (c) 2004-2013
  32  *
  33  */
  34
  35 /**
  36  * This class contains all contact related functions that are called using AJAX (jQuery)
  37  */
  38 class CRM_Contact_Page_AJAX {
  39   static function getContactList() {
  40     // if context is 'customfield'
  41     if (CRM_Utils_Array::value('context', $_GET) == 'customfield') {
  42       return self::contactReference();
  43     }
  44
  45     $params = array('version' => 3, 'check_permissions' => TRUE);
  46
  47     // String params
  48     // FIXME: param keys don't match input keys, using this array to translate
  49     $whitelist = array(
  50       's' => 'name',
  51       'fieldName' => 'field_name',
  52       'tableName' => 'table_name',
  53       'context' => 'context',
  54       'rel' => 'rel',
  55       'contact_sub_type' => 'contact_sub_type'
  56     );
  57     foreach ($whitelist as $key => $param) {
  58       if (!empty($_GET[$key])) {
  59         $params[$param] = $_GET[$key];
  60       }
  61     }
  62
  63     //CRM-10687: Allow quicksearch by multiple fields
  64     if (!empty($params['field_name'])) {
  65       if ($params['field_name'] == 'phone_numeric') {
  66         $params['name'] = preg_replace('/[^\d]/', '', $params['name']);
  67       }
  68       if (!$params['name']) {
  69         CRM_Utils_System::civiExit();
  70       }
  71     }
  72
  73     // Numeric params
  74     $whitelist = array(
  75       'limit',
  76       'org',
  77       'employee_id',
  78       'cid',
  79       'id',
  80       'cmsuser',
  81     );
  82     foreach ($whitelist as $key) {
  83       if (!empty($_GET[$key]) && is_numeric($_GET[$key])) {
  84         $params[$key] = $_GET[$key];
  85       }
  86     }
  87
  88     $result = civicrm_api('Contact', 'getquick', $params);
  89     if (empty($result['is_error']) && !empty($result['values'])) {
  90       foreach ($result['values'] as $key => $val) {
  91         echo "{$val['data']}|{$val['id']}\n";
  92       }
  93     }
  94     CRM_Utils_System::civiExit();
  95   }
  96
  97   static function contactReference() {
  98     $name = CRM_Utils_Array::value('s', $_GET);
  99     $name = CRM_Utils_Type::escape($name, 'String');
 100     $cfID = CRM_Utils_Type::escape($_GET['id'], 'Positive');
 101
 102     // check that this is a valid, active custom field of Contact Reference type
 103     $params           = array('id' => $cfID);
 104     $returnProperties = array('filter', 'data_type', 'is_active');
 105     $fldValues = $cf = array();
 106     CRM_Core_DAO::commonRetrieve('CRM_Core_DAO_CustomField', $params, $cf, $returnProperties);
 107     if (!$cf['id'] || !$cf['is_active'] || $cf['data_type'] = !'ContactReference') {
 108       echo "$name|error\n";
 109       CRM_Utils_System::civiExit();
 110     }
 111
 112     if (!empty($cf['filter'])) {
 113       $filterParams = array();
 114       parse_str($cf['filter'], $filterParams);
 115
 116       $action = CRM_Utils_Array::value('action', $filterParams);
 117
 118       if (!empty($action) &&
 119         !in_array($action, array('get', 'lookup'))
 120       ) {
 121         echo "$name|error\n";
 122         CRM_Utils_System::civiExit();
 123       }
 124     }
 125
 126     $list = array_keys(CRM_Core_BAO_Setting::valueOptions(CRM_Core_BAO_Setting::SYSTEM_PREFERENCES_NAME,
 127         'contact_reference_options'
 128       ), '1');
 129
 130     $return = array_unique(array_merge(array('sort_name'), $list));
 131
 132     $config = CRM_Core_Config::singleton();
 133
 134     $limit = 10;
 135     if (CRM_Utils_Array::value('limit', $_GET)) {
 136       $limit = CRM_Utils_Type::escape($_GET['limit'], 'Positive');
 137     }
 138
 139     $params = array('offset' => 0, 'rowCount' => $limit, 'version' => 3);
 140     foreach ($return as $fld) {
 141       $params["return.{$fld}"] = 1;
 142     }
 143
 144     if (!empty($action)) {
 145       $excludeGet = array('reset', 'key', 'className', 'fnName', 'json', 'reset', 'context', 'timestamp', 'limit', 'id', 's', 'q', 'action');
 146       foreach ($_GET as $param => $val) {
 147         if (empty($val) ||
 148           in_array($param, $excludeGet) ||
 149           strpos($param, 'return.') !== FALSE ||
 150           strpos($param, 'api.') !== FALSE
 151         ) {
 152           continue;
 153         }
 154         $params[$param] = $val;
 155       }
 156     }
 157
 158     if ($name) {
 159       $params['sort_name'] = $name;
 160     }
 161
 162     $params['sort'] = 'sort_name';
 163
 164     // tell api to skip permission chk. dgg
 165     $params['check_permissions'] = 0;
 166
 167     // add filter variable to params
 168     if (!empty($filterParams)) {
 169       $params = array_merge($params, $filterParams);
 170     }
 171
 172     $contact = civicrm_api('Contact', 'Get', $params);
 173
 174     if (CRM_Utils_Array::value('is_error', $contact)) {
 175       echo "$name|error\n";
 176       CRM_Utils_System::civiExit();
 177     }
 178
 179     $contactList = '';
 180     foreach ($contact['values'] as $value) {
 181       $view = array();
 182       foreach ($return as $fld) {
 183         if (CRM_Utils_Array::value($fld, $value)) {
 184           $view[] = $value[$fld];
 185         }
 186       }
 187       echo $contactList = implode(' :: ', $view) . "|" . $value['id'] . "\n";
 188     }
 189
 190     if (!$contactList) {
 191       echo "$name|$name\n";
 192     }
 193
 194     CRM_Utils_System::civiExit();
 195   }
 196
 197   /**
 198    * Function to fetch PCP ID by PCP Supporter sort_name, also displays PCP title and associated Contribution Page title
 199    */
 200   static function getPCPList() {
 201     $name  = CRM_Utils_Array::value('s', $_GET);
 202     $name  = CRM_Utils_Type::escape($name, 'String');
 203     $limit = '10';
 204
 205     $where = ' AND pcp.page_id = cp.id AND pcp.contact_id = cc.id';
 206
 207     $config = CRM_Core_Config::singleton();
 208     if ($config->includeWildCardInName) {
 209       $strSearch = "%$name%";
 210     }
 211     else {
 212       $strSearch = "$name%";
 213     }
 214     $includeEmailFrom = $includeNickName = '';
 215     if ($config->includeNickNameInName) {
 216       $includeNickName = " OR nick_name LIKE '$strSearch'";
 217     }
 218     if ($config->includeEmailInName) {
 219       $includeEmailFrom = "LEFT JOIN civicrm_email eml ON ( cc.id = eml.contact_id AND eml.is_primary = 1 )";
 220       $whereClause = " WHERE ( email LIKE '$strSearch' OR sort_name LIKE '$strSearch' $includeNickName ) {$where} ";
 221     }
 222     else {
 223       $whereClause = " WHERE ( sort_name LIKE '$strSearch' $includeNickName ) {$where} ";
 224     }
 225
 226     if (CRM_Utils_Array::value('limit', $_GET)) {
 227       $limit = CRM_Utils_Type::escape($_GET['limit'], 'Positive');
 228     }
 229
 230     $select = 'cc.sort_name, pcp.title, cp.title';
 231     $query = "
 232         SELECT id, data
 233         FROM (
 234             SELECT pcp.id as id, CONCAT_WS( ' :: ', {$select} ) as data, sort_name
 235             FROM civicrm_pcp pcp, civicrm_contribution_page cp, civicrm_contact cc
 236             {$includeEmailFrom}
 237             {$whereClause}
 238             LIMIT 0, {$limit}
 239             ) t
 240         ORDER BY sort_name
 241         ";
 242
 243     $dao = CRM_Core_DAO::executeQuery($query);
 244
 245     while ($dao->fetch()) {
 246       echo $pcpList = "$dao->data|$dao->id\n";
 247     }
 248
 249     CRM_Utils_System::civiExit();
 250   }
 251
 252   /**
 253    * Function to fetch the values
 254    */
 255   static function autocomplete() {
 256     $fieldID       = CRM_Utils_Type::escape($_GET['cfid'], 'Integer');
 257     $optionGroupID = CRM_Utils_Type::escape($_GET['ogid'], 'Integer');
 258     $label         = CRM_Utils_Type::escape($_GET['s'], 'String');
 259
 260     $selectOption = CRM_Core_BAO_CustomOption::valuesByID($fieldID, $optionGroupID);
 261
 262     $completeList = NULL;
 263     foreach ($selectOption as $id => $value) {
 264       if (strtolower($label) == strtolower(substr($value, 0, strlen($label)))) {
 265         echo $completeList = "$value|$id\n";
 266       }
 267     }
 268     CRM_Utils_System::civiExit();
 269   }
 270
 271   static function relationship() {
 272     $relType         = CRM_Utils_Array::value('rel_type', $_REQUEST);
 273     $relContactID    = CRM_Utils_Array::value('rel_contact', $_REQUEST);
 274     $sourceContactID = CRM_Utils_Array::value('contact_id', $_REQUEST); // we no longer need this.
 275     $relationshipID  = CRM_Utils_Array::value('rel_id', $_REQUEST); // this used only to determine add or update mode
 276     $caseID          = CRM_Utils_Array::value('case_id', $_REQUEST);
 277
 278     // check if there are multiple clients for this case, if so then we need create
 279     // relationship and also activities for each contacts
 280
 281     // get case client list
 282     $clientList = CRM_Case_BAO_Case::getCaseClients($caseID);
 283
 284     foreach($clientList as $sourceContactID) {
 285       $relationParams = array(
 286         'relationship_type_id' => $relType . '_a_b',
 287         'contact_check' => array($relContactID => 1),
 288         'is_active' => 1,
 289         'case_id' => $caseID,
 290         'start_date' => date("Ymd"),
 291       );
 292
 293       $relationIds = array('contact' => $sourceContactID);
 294
 295       // check if we are editing/updating existing relationship
 296       if ($relationshipID && $relationshipID != 'null') {
 297         // here we need to retrieve appropriate relationshipID based on client id and relationship type id
 298         $caseRelationships = new CRM_Contact_DAO_Relationship();
 299         $caseRelationships->case_id = $caseID;
 300         $caseRelationships->relationship_type_id = $relType;
 301         $caseRelationships->contact_id_a = $sourceContactID;
 302         $caseRelationships->find();
 303
 304         while($caseRelationships->fetch()) {
 305           $relationIds['relationship'] = $caseRelationships->id;
 306           $relationIds['contactTarget'] = $relContactID;
 307         }
 308         $caseRelationships->free();
 309       }
 310
 311       // create new or update existing relationship
 312       $return = CRM_Contact_BAO_Relationship::create($relationParams, $relationIds);
 313
 314       $status = 'process-relationship-fail';
 315       if (CRM_Utils_Array::value(0, $return[4])) {
 316         $relationshipID = $return[4][0];
 317         $status = 'process-relationship-success';
 318
 319         //create an activity for case role assignment.CRM-4480
 320         CRM_Case_BAO_Case::createCaseRoleActivity($caseID, $relationshipID, $relContactID);
 321       }
 322     }
 323
 324     $relation['status'] = $status;
 325     echo json_encode($relation);
 326     CRM_Utils_System::civiExit();
 327   }
 328
 329   /**
 330    * Function to fetch the custom field help
 331    */
 332   static function customField() {
 333     $fieldId          = CRM_Utils_Type::escape($_REQUEST['id'], 'Integer');
 334     $params           = array('id' => $fieldId);
 335     $returnProperties = array('help_pre', 'help_post');
 336     $values           = array();
 337
 338     CRM_Core_DAO::commonRetrieve('CRM_Core_DAO_CustomField', $params, $values, $returnProperties);
 339     echo json_encode($values);
 340     CRM_Utils_System::civiExit();
 341   }
 342
 343   static function groupTree() {
 344     $gids = CRM_Utils_Type::escape($_GET['gids'], 'String');
 345     echo CRM_Contact_BAO_GroupNestingCache::json($gids);
 346     CRM_Utils_System::civiExit();
 347   }
 348
 349   /**
 350    * Function for building contact combo box
 351    */
 352   static function search() {
 353     $json = TRUE;
 354     $name = CRM_Utils_Array::value('name', $_GET, '');
 355     if (!array_key_exists('name', $_GET)) {
 356       $name = CRM_Utils_Array::value('s', $_GET) . '%';
 357       $json = FALSE;
 358     }
 359     $name = CRM_Utils_Type::escape($name, 'String');
 360     $whereIdClause = '';
 361     if (CRM_Utils_Array::value('id', $_GET)) {
 362       $json = TRUE;
 363       if (is_numeric($_GET['id'])) {
 364         $id = CRM_Utils_Type::escape($_GET['id'], 'Integer');
 365         $whereIdClause = " AND civicrm_contact.id = {$id}";
 366       }
 367       else {
 368         $name = $_GET['id'];
 369       }
 370     }
 371
 372     $elements = array();
 373     if ($name || isset($id)) {
 374       $name = $name . '%';
 375
 376       //contact's based of relationhip type
 377       $relType = NULL;
 378       if (isset($_GET['rel'])) {
 379         $relation = explode('_', $_GET['rel']);
 380         $relType  = CRM_Utils_Type::escape($relation[0], 'Integer');
 381         $rel      = CRM_Utils_Type::escape($relation[2], 'String');
 382       }
 383
 384       //shared household info
 385       $shared = NULL;
 386       if (isset($_GET['sh'])) {
 387         $shared = CRM_Utils_Type::escape($_GET['sh'], 'Integer');
 388         if ($shared == 1) {
 389           $contactType = 'Household';
 390           $cName = 'household_name';
 391         }
 392         else {
 393           $contactType = 'Organization';
 394           $cName = 'organization_name';
 395         }
 396       }
 397
 398       // contacts of type household
 399       $hh = $addStreet = $addCity = NULL;
 400       if (isset($_GET['hh'])) {
 401         $hh = CRM_Utils_Type::escape($_GET['hh'], 'Integer');
 402       }
 403
 404       //organization info
 405       $organization = $street = $city = NULL;
 406       if (isset($_GET['org'])) {
 407         $organization = CRM_Utils_Type::escape($_GET['org'], 'Integer');
 408       }
 409
 410       if (isset($_GET['org']) || isset($_GET['hh'])) {
 411         $json = FALSE;
 412         if ($splitName = explode(' :: ', $name)) {
 413           $contactName = trim(CRM_Utils_Array::value('0', $splitName));
 414           $street      = trim(CRM_Utils_Array::value('1', $splitName));
 415           $city        = trim(CRM_Utils_Array::value('2', $splitName));
 416         }
 417         else {
 418           $contactName = $name;
 419         }
 420
 421         if ($street) {
 422           $addStreet = "AND civicrm_address.street_address LIKE '$street%'";
 423         }
 424         if ($city) {
 425           $addCity = "AND civicrm_address.city LIKE '$city%'";
 426         }
 427       }
 428
 429       if ($organization) {
 430
 431         $query = "
 432 SELECT CONCAT_WS(' :: ',sort_name,LEFT(street_address,25),city) 'sort_name',
 433 civicrm_contact.id 'id'
 434 FROM civicrm_contact
 435 LEFT JOIN civicrm_address ON ( civicrm_contact.id = civicrm_address.contact_id
 436                                 AND civicrm_address.is_primary=1
 437                              )
 438 WHERE civicrm_contact.contact_type='Organization' AND organization_name LIKE '%$contactName%'
 439 {$addStreet} {$addCity} {$whereIdClause}
 440 ORDER BY organization_name ";
 441       }
 442       elseif ($shared) {
 443         $query = "
 444 SELECT CONCAT_WS(':::' , sort_name, supplemental_address_1, sp.abbreviation, postal_code, cc.name )'sort_name' , civicrm_contact.id 'id' , civicrm_contact.display_name 'disp' FROM civicrm_contact LEFT JOIN civicrm_address ON (civicrm_contact.id =civicrm_address.contact_id AND civicrm_address.is_primary =1 )LEFT JOIN civicrm_state_province sp ON (civicrm_address.state_province_id =sp.id )LEFT JOIN civicrm_country cc ON (civicrm_address.country_id =cc.id )WHERE civicrm_contact.contact_type ='{$contactType}' AND {$cName} LIKE '%$name%' {$whereIdClause} ORDER BY {$cName} ";
 445       }
 446       elseif ($hh) {
 447         $query = "
 448 SELECT CONCAT_WS(' :: ' , sort_name, LEFT(street_address,25),city) 'sort_name' , location_type_id 'location_type_id', is_primary 'is_primary', is_billing 'is_billing', civicrm_contact.id 'id'
 449 FROM civicrm_contact
 450 LEFT JOIN civicrm_address ON (civicrm_contact.id =civicrm_address.contact_id AND civicrm_address.is_primary =1 )
 451 WHERE civicrm_contact.contact_type ='Household'
 452 AND household_name LIKE '%$contactName%' {$addStreet} {$addCity} {$whereIdClause} ORDER BY household_name ";
 453       }
 454       elseif ($relType) {
 455         if (CRM_Utils_Array::value('case', $_GET)) {
 456           $query = "
 457 SELECT distinct(c.id), c.sort_name
 458 FROM civicrm_contact c
 459 LEFT JOIN civicrm_relationship ON civicrm_relationship.contact_id_{$rel} = c.id
 460 WHERE c.sort_name LIKE '%$name%'
 461 AND civicrm_relationship.relationship_type_id = $relType
 462 GROUP BY sort_name
 463 ";
 464         }
 465       }
 466       else {
 467
 468         $query = "
 469 SELECT sort_name, id
 470 FROM civicrm_contact
 471 WHERE sort_name LIKE '%$name'
 472 {$whereIdClause}
 473 ORDER BY sort_name ";
 474       }
 475
 476       $limit = 10;
 477       if (isset($_GET['limit'])) {
 478         $limit = CRM_Utils_Type::escape($_GET['limit'], 'Positive');
 479       }
 480
 481       $query .= " LIMIT 0,{$limit}";
 482
 483       $dao = CRM_Core_DAO::executeQuery($query);
 484
 485       if ($shared) {
 486         while ($dao->fetch()) {
 487           echo $dao->sort_name;
 488           CRM_Utils_System::civiExit();
 489         }
 490       }
 491       else {
 492         while ($dao->fetch()) {
 493           if ($json) {
 494             $elements[] = array('name' => addslashes($dao->sort_name),
 495               'id' => $dao->id,
 496             );
 497           }
 498           else {
 499             echo $elements = "$dao->sort_name|$dao->id|$dao->location_type_id|$dao->is_primary|$dao->is_billing\n";
 500           }
 501         }
 502         //for adding new household address / organization
 503         if (empty($elements) && !$json && ($hh || $organization)) {
 504           echo CRM_Utils_Array::value('s', $_GET);
 505         }
 506       }
 507     }
 508
 509     if (isset($_GET['sh'])) {
 510       echo "";
 511       CRM_Utils_System::civiExit();
 512     }
 513
 514     if (empty($elements)) {
 515       $name = str_replace('%', '', $name);
 516       $elements[] = array(
 517         'name' => $name,
 518         'id' => $name,
 519       );
 520     }
 521
 522     if ($json) {
 523       echo json_encode($elements);
 524     }
 525     CRM_Utils_System::civiExit();
 526   }
 527
 528   /**
 529    *
 530    * Function to check how many contact exits in db for given criteria,
 531    * if one then return contact id else null
 532    */
 533   static function contact() {
 534     $name = CRM_Utils_Type::escape($_GET['name'], 'String');
 535
 536     $query = "
 537 SELECT id
 538 FROM civicrm_contact
 539 WHERE sort_name LIKE '%$name%'";
 540
 541     $dao = CRM_Core_DAO::executeQuery($query);
 542     $dao->fetch();
 543
 544     if ($dao->N == 1) {
 545       echo $dao->id;
 546     }
 547     CRM_Utils_System::civiExit();
 548   }
 549
 550   /**
 551    * Function to delete custom value
 552    *
 553    */
 554   static function deleteCustomValue() {
 555     $customValueID = CRM_Utils_Type::escape($_REQUEST['valueID'], 'Positive');
 556     $customGroupID = CRM_Utils_Type::escape($_REQUEST['groupID'], 'Positive');
 557
 558     CRM_Core_BAO_CustomValue::deleteCustomValue($customValueID, $customGroupID);
 559     if ($contactId = CRM_Utils_Array::value('contactId', $_REQUEST)) {
 560       echo CRM_Contact_BAO_Contact::getCountComponent('custom_' . $_REQUEST['groupID'], $contactId);
 561     }
 562
 563     // reset the group contact cache for this group
 564     CRM_Contact_BAO_GroupContactCache::remove();
 565     CRM_Utils_System::civiExit();
 566   }
 567
 568   /**
 569    * Function to perform enable / disable actions on record.
 570    *
 571    */
 572   static function enableDisable() {
 573     $op        = CRM_Utils_Type::escape($_REQUEST['op'], 'String');
 574     $recordID  = CRM_Utils_Type::escape($_REQUEST['recordID'], 'Positive');
 575     $recordBAO = CRM_Utils_Type::escape($_REQUEST['recordBAO'], 'String');
 576
 577     $isActive = NULL;
 578     if ($op == 'disable-enable') {
 579       $isActive = TRUE;
 580     }
 581     elseif ($op == 'enable-disable') {
 582       $isActive = FALSE;
 583     }
 584     $status = array('status' => 'record-updated-fail');
 585     if (isset($isActive)) {
 586       // first munge and clean the recordBAO and get rid of any non alpha numeric characters
 587       $recordBAO = CRM_Utils_String::munge($recordBAO);
 588       $recordClass = explode('_', $recordBAO);
 589
 590       // make sure recordClass is namespaced (we cant check CRM since extensions can also use this)
 591       // but it should be at least 3 levels deep
 592       if (count($recordClass) >= 3) {
 593         require_once (str_replace('_', DIRECTORY_SEPARATOR, $recordBAO) . ".php");
 594         $method = 'setIsActive';
 595
 596         if (method_exists($recordBAO, $method)) {
 597           $updated = call_user_func_array(array($recordBAO, $method),
 598             array($recordID, $isActive)
 599           );
 600           if ($updated) {
 601             $status = array('status' => 'record-updated-success');
 602           }
 603
 604           // call hook enableDisable
 605           CRM_Utils_Hook::enableDisable($recordBAO, $recordID, $isActive);
 606         }
 607       }
 608       echo json_encode($status);
 609       CRM_Utils_System::civiExit();
 610     }
 611   }
 612
 613   /**
 614      *Function to check the CMS username
 615      *
 616     */
 617   static public function checkUserName() {
 618     $config = CRM_Core_Config::singleton();
 619     $username = trim($_REQUEST['cms_name']);
 620
 621     $params = array('name' => $username);
 622
 623     $errors = array();
 624     $config->userSystem->checkUserNameEmailExists($params, $errors);
 625
 626     if (isset($errors['cms_name']) || isset($errors['name'])) {
 627       //user name is not availble
 628       $user = array('name' => 'no');
 629       echo json_encode($user);
 630     }
 631     else {
 632       //user name is available
 633       $user = array('name' => 'yes');
 634       echo json_encode($user);
 635     }
 636     CRM_Utils_System::civiExit();
 637   }
 638
 639   /**
 640    *  Function to get email address of a contact
 641    */
 642   static function getContactEmail() {
 643     if (CRM_Utils_Array::value('contact_id', $_REQUEST)) {
 644       $contactID = CRM_Utils_Type::escape($_REQUEST['contact_id'], 'Positive');
 645       list($displayName,
 646         $userEmail
 647       ) = CRM_Contact_BAO_Contact_Location::getEmailDetails($contactID);
 648       if ($userEmail) {
 649         echo $userEmail;
 650       }
 651     }
 652     else {
 653       $noemail = CRM_Utils_Array::value('noemail', $_GET);
 654       $queryString = NULL;
 655       if ($name = CRM_Utils_Array::value('name', $_GET)) {
 656         $name = CRM_Utils_Type::escape($name, 'String');
 657         if ($noemail) {
 658           $queryString = " cc.sort_name LIKE '%$name%'";
 659         }
 660         else {
 661           $queryString = " ( cc.sort_name LIKE '%$name%' OR ce.email LIKE '%$name%' ) ";
 662         }
 663       }
 664       elseif ($cid = CRM_Utils_Array::value('cid', $_GET)) {
 665         //check cid for interger
 666         $contIDS = explode(',', $cid);
 667         foreach ($contIDS as $contID) {
 668           CRM_Utils_Type::escape($contID, 'Integer');
 669         }
 670         $queryString = " cc.id IN ( $cid )";
 671       }
 672
 673       if ($queryString) {
 674         $offset = CRM_Utils_Array::value('offset', $_GET, 0);
 675         $rowCount = CRM_Utils_Array::value('rowcount', $_GET, 20);
 676
 677         $offset = CRM_Utils_Type::escape($offset, 'Int');
 678         $rowCount = CRM_Utils_Type::escape($rowCount, 'Int');
 679
 680         // add acl clause here
 681         list($aclFrom, $aclWhere) = CRM_Contact_BAO_Contact_Permission::cacheClause('cc');
 682         if ($aclWhere) {
 683           $aclWhere = " AND $aclWhere";
 684         }
 685         if ($noemail) {
 686           $query = "
 687 SELECT sort_name name, cc.id
 688 FROM civicrm_contact cc
 689      {$aclFrom}
 690 WHERE cc.is_deceased = 0 AND {$queryString}
 691       {$aclWhere}
 692 LIMIT {$offset}, {$rowCount}
 693 ";
 694
 695           // send query to hook to be modified if needed
 696           CRM_Utils_Hook::contactListQuery($query,
 697             $name,
 698             CRM_Utils_Array::value('context', $_GET),
 699             CRM_Utils_Array::value('cid', $_GET)
 700           );
 701
 702           $dao = CRM_Core_DAO::executeQuery($query);
 703           while ($dao->fetch()) {
 704             $result[] = array(
 705               'name' => $dao->name,
 706               'id' => $dao->id,
 707             );
 708           }
 709         }
 710         else {
 711           $query = "
 712 SELECT sort_name name, ce.email, cc.id
 713 FROM   civicrm_email ce INNER JOIN civicrm_contact cc ON cc.id = ce.contact_id
 714        {$aclFrom}
 715 WHERE  ce.on_hold = 0 AND cc.is_deceased = 0 AND cc.do_not_email = 0 AND {$queryString}
 716        {$aclWhere}
 717 LIMIT {$offset}, {$rowCount}
 718 ";
 719
 720           // send query to hook to be modified if needed
 721           CRM_Utils_Hook::contactListQuery($query,
 722             $name,
 723             CRM_Utils_Array::value('context', $_GET),
 724             CRM_Utils_Array::value('cid', $_GET)
 725           );
 726
 727
 728           $dao = CRM_Core_DAO::executeQuery($query);
 729
 730           while ($dao->fetch()) {
 731             $result[] = array(
 732               'name' => '"' . $dao->name . '" &lt;' . $dao->email . '&gt;',
 733               'id' => (CRM_Utils_Array::value('id', $_GET)) ? "{$dao->id}::{$dao->email}" : '"' . $dao->name . '" <' . $dao->email . '>',
 734             );
 735           }
 736         }
 737
 738         if ($result) {
 739           echo json_encode($result);
 740         }
 741       }
 742     }
 743     CRM_Utils_System::civiExit();
 744   }
 745
 746   static function getContactPhone() {
 747
 748     $queryString = NULL;
 749     //check for mobile type
 750     $phoneTypes = CRM_Core_OptionGroup::values('phone_type', TRUE, FALSE, FALSE, NULL, 'name');
 751     $mobileType = CRM_Utils_Array::value('Mobile', $phoneTypes);
 752
 753     if ($name = CRM_Utils_Array::value('name', $_GET)) {
 754       $name = CRM_Utils_Type::escape($name, 'String');
 755       $queryString = " ( cc.sort_name LIKE '%$name%' OR cp.phone LIKE '%$name%' ) ";
 756     }
 757     elseif ($cid = CRM_Utils_Array::value('cid', $_GET)) {
 758       //check cid for interger
 759       $contIDS = explode(',', $cid);
 760       foreach ($contIDS as $contID) {
 761         CRM_Utils_Type::escape($contID, 'Integer');
 762       }
 763       $queryString = " cc.id IN ( $cid )";
 764     }
 765
 766     if ($queryString) {
 767       $offset = CRM_Utils_Array::value('offset', $_GET, 0);
 768       $rowCount = CRM_Utils_Array::value('rowcount', $_GET, 20);
 769
 770       $offset = CRM_Utils_Type::escape($offset, 'Int');
 771       $rowCount = CRM_Utils_Type::escape($rowCount, 'Int');
 772
 773       // add acl clause here
 774       list($aclFrom, $aclWhere) = CRM_Contact_BAO_Contact_Permission::cacheClause('cc');
 775       if ($aclWhere) {
 776         $aclWhere = " AND $aclWhere";
 777       }
 778
 779       $query = "
 780 SELECT sort_name name, cp.phone, cc.id
 781 FROM   civicrm_phone cp INNER JOIN civicrm_contact cc ON cc.id = cp.contact_id
 782        {$aclFrom}
 783 WHERE  cc.is_deceased = 0 AND cc.do_not_sms = 0 AND cp.phone_type_id = {$mobileType} AND {$queryString}
 784        {$aclWhere}
 785 LIMIT {$offset}, {$rowCount}
 786 ";
 787
 788       // send query to hook to be modified if needed
 789       CRM_Utils_Hook::contactListQuery($query,
 790         $name,
 791         CRM_Utils_Array::value('context', $_GET),
 792         CRM_Utils_Array::value('cid', $_GET)
 793       );
 794
 795       $dao = CRM_Core_DAO::executeQuery($query);
 796
 797       while ($dao->fetch()) {
 798         $result[] = array(
 799           'name' => '"' . $dao->name . '" &lt;' . $dao->phone . '&gt;',
 800           'id' => (CRM_Utils_Array::value('id', $_GET)) ? "{$dao->id}::{$dao->phone}" : '"' . $dao->name . '" <' . $dao->phone . '>',
 801         );
 802       }
 803     }
 804
 805     if ($result) {
 806       echo json_encode($result);
 807     }
 808     CRM_Utils_System::civiExit();
 809   }
 810
 811
 812   static function buildSubTypes() {
 813     $parent = CRM_Utils_Array::value('parentId', $_REQUEST);
 814
 815     switch ($parent) {
 816       case 1:
 817         $contactType = 'Individual';
 818         break;
 819
 820       case 2:
 821         $contactType = 'Household';
 822         break;
 823
 824       case 4:
 825         $contactType = 'Organization';
 826         break;
 827     }
 828
 829     $subTypes = CRM_Contact_BAO_ContactType::subTypePairs($contactType, FALSE, NULL);
 830     asort($subTypes);
 831     echo json_encode($subTypes);
 832     CRM_Utils_System::civiExit();
 833   }
 834
 835   static function buildDedupeRules() {
 836     $parent = CRM_Utils_Array::value('parentId', $_REQUEST);
 837
 838     switch ($parent) {
 839       case 1:
 840         $contactType = 'Individual';
 841         break;
 842
 843       case 2:
 844         $contactType = 'Household';
 845         break;
 846
 847       case 4:
 848         $contactType = 'Organization';
 849         break;
 850     }
 851
 852     $dedupeRules = CRM_Dedupe_BAO_RuleGroup::getByType($contactType);
 853
 854     echo json_encode($dedupeRules);
 855     CRM_Utils_System::civiExit();
 856   }
 857
 858   /**
 859    * Function used for CiviCRM dashboard operations
 860    */
 861   static function dashboard() {
 862     $operation = CRM_Utils_Type::escape($_REQUEST['op'], 'String');
 863
 864     switch ($operation) {
 865       case 'get_widgets_by_column':
 866         // This would normally be coming from either the database (this user's settings) or a default/initial dashboard configuration.
 867         // get contact id of logged in user
 868
 869         $dashlets = CRM_Core_BAO_Dashboard::getContactDashlets();
 870         break;
 871
 872       case 'get_widget':
 873         $dashletID = CRM_Utils_Type::escape($_GET['id'], 'Positive');
 874
 875         $dashlets = CRM_Core_BAO_Dashboard::getDashletInfo($dashletID);
 876         break;
 877
 878       case 'save_columns':
 879         CRM_Core_BAO_Dashboard::saveDashletChanges($_REQUEST['columns']);
 880         CRM_Utils_System::civiExit();
 881       case 'delete_dashlet':
 882         $dashletID = CRM_Utils_Type::escape($_REQUEST['dashlet_id'], 'Positive');
 883         CRM_Core_BAO_Dashboard::deleteDashlet($dashletID);
 884         CRM_Utils_System::civiExit();
 885     }
 886
 887     echo json_encode($dashlets);
 888     CRM_Utils_System::civiExit();
 889   }
 890
 891   /**
 892    * Function to retrieve signature based on email id
 893    */
 894   static function getSignature() {
 895     $emailID = CRM_Utils_Type::escape($_REQUEST['emailID'], 'Positive');
 896     $query   = "SELECT signature_text, signature_html FROM civicrm_email WHERE id = {$emailID}";
 897     $dao     = CRM_Core_DAO::executeQuery($query);
 898
 899     $signatures = array();
 900     while ($dao->fetch()) {
 901       $signatures = array(
 902         'signature_text' => $dao->signature_text,
 903         'signature_html' => $dao->signature_html,
 904       );
 905     }
 906
 907     echo json_encode($signatures);
 908     CRM_Utils_System::civiExit();
 909   }
 910
 911   static function relationshipContacts() {
 912     $searchValues = $searchRows = array();
 913     $addCount = 0;
 914
 915     $relType          = CRM_Utils_Type::escape($_REQUEST['relType'], 'String');
 916     $typeName         = isset($_REQUEST['typeName']) ? CRM_Utils_Type::escape($_REQUEST['typeName'], 'String') : '';
 917     $relContact       = CRM_Utils_Type::escape($_REQUEST['relContact'], 'String');
 918     $currentContactId = CRM_Utils_Type::escape($_REQUEST['cid'], 'Integer');
 919
 920     if (in_array($typeName, array(
 921       'Employee of', 'Employer of'))) {
 922       $addCount = 1;
 923     }
 924
 925     $sortMapper = array(
 926       1 => 'sort_name', (2 + $addCount) => 'city', (3 + $addCount) => 'state_province',
 927       (4 + $addCount) => 'email', (5 + $addCount) => 'phone',
 928     );
 929
 930     $sEcho     = CRM_Utils_Type::escape($_REQUEST['sEcho'], 'Integer');
 931     $offset    = isset($_REQUEST['iDisplayStart']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayStart'], 'Integer') : 0;
 932     $rowCount  = isset($_REQUEST['iDisplayLength']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayLength'], 'Integer') : 25;
 933     $sort      = isset($_REQUEST['iSortCol_0']) ? $sortMapper[CRM_Utils_Type::escape($_REQUEST['iSortCol_0'], 'Integer')] : 'sort_name';
 934     $sortOrder = isset($_REQUEST['sSortDir_0']) ? CRM_Utils_Type::escape($_REQUEST['sSortDir_0'], 'String') : 'asc';
 935
 936     $searchValues[] = array('sort_name', 'LIKE', $relContact, 0, 1);
 937
 938     list($rid, $direction) = explode('_', $relType, 2);
 939
 940     $relationshipType = new CRM_Contact_DAO_RelationshipType();
 941
 942     $relationshipType->id = $rid;
 943     if ($relationshipType->find(TRUE)) {
 944       if ($direction == 'a_b') {
 945         $type = $relationshipType->contact_type_b;
 946         $subType = $relationshipType->contact_sub_type_b;
 947       }
 948       else {
 949         $type = $relationshipType->contact_type_a;
 950         $subType = $relationshipType->contact_sub_type_a;
 951       }
 952
 953       if ($type == 'Individual' || $type == 'Organization' || $type == 'Household') {
 954         $searchValues[] = array('contact_type', '=', $type, 0, 0);
 955       }
 956
 957       if ($subType) {
 958         $searchValues[] = array('contact_sub_type', '=', $subType, 0, 0);
 959       }
 960     }
 961
 962     // exclude current contact
 963     $searchValues[] = array('contact_id', '!=', $currentContactId, 0, 0);
 964
 965     $query       = new CRM_Contact_BAO_Query($searchValues);
 966     $searchCount = $query->searchQuery(0, 0, NULL, TRUE);
 967     $iTotal      = $searchCount;
 968
 969     if ($searchCount > 0) {
 970       // get the result of the search
 971       $result = $query->searchQuery($offset, $rowCount, $sort, FALSE, FALSE,
 972         FALSE, FALSE, FALSE, NULL, $sortOrder
 973       );
 974
 975       $config = CRM_Core_Config::singleton();
 976
 977       while ($result->fetch()) {
 978         $query->convertToPseudoNames($result);
 979         $contactID = $result->contact_id;
 980         $typeImage = CRM_Contact_BAO_Contact_Utils::getImage($result->contact_sub_type ?
 981           $result->contact_sub_type : $result->contact_type,
 982           FALSE, $contactID
 983         );
 984
 985         $searchRows[$contactID]['id'] = $contactID;
 986         $searchRows[$contactID]['name'] = $typeImage . ' ' . $result->sort_name;
 987         $searchRows[$contactID]['city'] = $result->city;
 988         $searchRows[$contactID]['state'] = $result->state_province;
 989         $searchRows[$contactID]['email'] = $result->email;
 990         $searchRows[$contactID]['phone'] = $result->phone;
 991       }
 992     }
 993
 994     foreach ($searchRows as $cid => $row) {
 995       $searchRows[$cid]['check'] = '<input type="checkbox" id="contact_check[' . $cid . ']" name="contact_check[' . $cid . ']" value=' . $cid . ' />';
 996
 997       if ($typeName == 'Employee of') {
 998         $searchRows[$cid]['employee_of'] = '<input type="radio" name="employee_of" value=' . $cid . ' >';
 999       }
1000       elseif ($typeName == 'Employer of') {
1001         $searchRows[$cid]['employer_of'] = '<input type="checkbox"  name="employer_of[' . $cid . ']" value=' . $cid . ' />';
1002       }
1003     }
1004
1005     $selectorElements = array('check', 'name');
1006     if ($typeName == 'Employee of') {
1007       $selectorElements[] = 'employee_of';
1008     }
1009     elseif ($typeName == 'Employer of') {
1010       $selectorElements[] = 'employer_of';
1011     }
1012     $selectorElements = array_merge($selectorElements, array('city', 'state', 'email', 'phone'));
1013
1014     $iFilteredTotal = $iTotal;
1015     echo CRM_Utils_JSON::encodeDataTableSelector($searchRows, $sEcho, $iTotal, $iFilteredTotal, $selectorElements);
1016     CRM_Utils_System::civiExit();
1017   }
1018
1019   /**
1020    * Function to process dupes.
1021    *
1022    */
1023   static function processDupes() {
1024     $oper = CRM_Utils_Type::escape($_REQUEST['op'], 'String');
1025     $cid  = CRM_Utils_Type::escape($_REQUEST['cid'], 'Positive');
1026     $oid  = CRM_Utils_Type::escape($_REQUEST['oid'], 'Positive');
1027
1028     if (!$oper || !$cid || !$oid) {
1029       return;
1030     }
1031
1032     $exception = new CRM_Dedupe_DAO_Exception();
1033     $exception->contact_id1 = $cid;
1034     $exception->contact_id2 = $oid;
1035     //make sure contact2 > contact1.
1036     if ($cid > $oid) {
1037       $exception->contact_id1 = $oid;
1038       $exception->contact_id2 = $cid;
1039     }
1040     $exception->find(TRUE);
1041     $status = NULL;
1042     if ($oper == 'dupe-nondupe') {
1043       $status = $exception->save();
1044     }
1045     if ($oper == 'nondupe-dupe') {
1046       $status = $exception->delete();
1047     }
1048
1049     echo json_encode(array('status' => ($status) ? $oper : $status));
1050     CRM_Utils_System::civiExit();
1051   }
1052
1053   static function getDedupes() {
1054
1055     $sEcho     = CRM_Utils_Type::escape($_REQUEST['sEcho'], 'Integer');
1056     $offset    = isset($_REQUEST['iDisplayStart']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayStart'], 'Integer') : 0;
1057     $rowCount  = isset($_REQUEST['iDisplayLength']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayLength'], 'Integer') : 25;
1058     $sort      = 'sort_name';
1059     $sortOrder = isset($_REQUEST['sSortDir_0']) ? CRM_Utils_Type::escape($_REQUEST['sSortDir_0'], 'String') : 'asc';
1060
1061     $gid         = isset($_REQUEST['gid']) ? CRM_Utils_Type::escape($_REQUEST['gid'], 'Integer') : 0;
1062     $rgid        = isset($_REQUEST['rgid']) ? CRM_Utils_Type::escape($_REQUEST['rgid'], 'Integer') : 0;
1063     $contactType = '';
1064     if ($rgid) {
1065       $contactType = CRM_Core_DAO::getFieldValue('CRM_Dedupe_DAO_RuleGroup', $rgid, 'contact_type');
1066     }
1067
1068     $cacheKeyString   = "merge {$contactType}_{$rgid}_{$gid}";
1069     $searchRows       = array();
1070     $selectorElements = array('src', 'dst', 'weight', 'actions');
1071
1072
1073     $join = "LEFT JOIN civicrm_dedupe_exception de ON ( pn.entity_id1 = de.contact_id1 AND
1074                                                              pn.entity_id2 = de.contact_id2 )";
1075     $where = "de.id IS NULL";
1076
1077     $iFilteredTotal = $iTotal = CRM_Core_BAO_PrevNextCache::getCount($cacheKeyString, $join, $where);
1078     $mainContacts = CRM_Core_BAO_PrevNextCache::retrieve($cacheKeyString, $join, $where, $offset, $rowCount);
1079
1080     foreach ($mainContacts as $mainId => $main) {
1081       $searchRows[$mainId]['src'] = CRM_Utils_System::href($main['srcName'], 'civicrm/contact/view', "reset=1&cid={$main['srcID']}");
1082       $searchRows[$mainId]['dst'] = CRM_Utils_System::href($main['dstName'], 'civicrm/contact/view', "reset=1&cid={$main['dstID']}");
1083       $searchRows[$mainId]['weight'] = CRM_Utils_Array::value('weight', $main);
1084
1085       if (CRM_Utils_Array::value('canMerge', $main)) {
1086         $mergeParams = "reset=1&cid={$main['srcID']}&oid={$main['dstID']}&action=update&rgid={$rgid}";
1087         if ($gid) {
1088           $mergeParams .= "&gid={$gid}";
1089         }
1090
1091         $searchRows[$mainId]['actions'] = CRM_Utils_System::href(ts('merge'), 'civicrm/contact/merge', $mergeParams);
1092         $searchRows[$mainId]['actions'] .= "&nbsp;|&nbsp; <a id='notDuplicate' href='#' onClick=\"processDupes( {$main['srcID']}, {$main['dstID']}, 'dupe-nondupe', 'dupe-listing'); return false;\">" . ts('not a duplicate') . "</a>";
1093       }
1094       else {
1095         $searchRows[$mainId]['actions'] = '<em>' . ts('Insufficient access rights - cannot merge') . '</em>';
1096       }
1097     }
1098
1099     echo CRM_Utils_JSON::encodeDataTableSelector($searchRows, $sEcho, $iTotal, $iFilteredTotal, $selectorElements);
1100
1101     CRM_Utils_System::civiExit();
1102   }
1103
1104   /**
1105    * Function to retrieve a PDF Page Format for the PDF Letter form
1106    */
1107   function pdfFormat() {
1108     $formatId = CRM_Utils_Type::escape($_REQUEST['formatId'], 'Integer');
1109
1110     $pdfFormat = CRM_Core_BAO_PdfFormat::getById($formatId);
1111
1112     echo json_encode($pdfFormat);
1113     CRM_Utils_System::civiExit();
1114   }
1115
1116   /**
1117    * Function to retrieve Paper Size dimensions
1118    */
1119   static function paperSize() {
1120     $paperSizeName = CRM_Utils_Type::escape($_REQUEST['paperSizeName'], 'String');
1121
1122     $paperSize = CRM_Core_BAO_PaperSize::getByName($paperSizeName);
1123
1124     echo json_encode($paperSize);
1125     CRM_Utils_System::civiExit();
1126   }
1127
1128   static function relationshipContactTypeList() {
1129     $relType = CRM_Utils_Array::value('relType', $_REQUEST);
1130
1131     $types = CRM_Contact_BAO_Relationship::getValidContactTypeList($relType);
1132
1133     $elements = array();
1134     foreach ($types as $key => $label) {
1135       $elements[] = array(
1136         'name' => $label,
1137         'value' => $key,
1138       );
1139     }
1140
1141     echo json_encode($elements);
1142     CRM_Utils_System::civiExit();
1143   }
1144
1145   static function selectUnselectContacts() {
1146     $name         = CRM_Utils_Array::value('name', $_REQUEST);
1147     $cacheKey     = CRM_Utils_Array::value('qfKey', $_REQUEST);
1148     $state        = CRM_Utils_Array::value('state', $_REQUEST, 'checked');
1149     $variableType = CRM_Utils_Array::value('variableType', $_REQUEST, 'single');
1150
1151     $actionToPerform = CRM_Utils_Array::value('action', $_REQUEST, 'select');
1152
1153     if ($variableType == 'multiple') {
1154       // action post value only works with multiple type variable
1155       if ($name) {
1156         //multiple names like mark_x_1-mark_x_2 where 1,2 are cids
1157         $elements = explode('-', $name);
1158         foreach ($elements as $key => $element) {
1159           $elements[$key] = self::_convertToId($element);
1160         }
1161         CRM_Core_BAO_PrevNextCache::markSelection($cacheKey, $actionToPerform, $elements);
1162       }
1163       else {
1164         CRM_Core_BAO_PrevNextCache::markSelection($cacheKey, $actionToPerform);
1165       }
1166     }
1167     elseif ($variableType == 'single') {
1168       $cId = self::_convertToId($name);
1169       $action = ($state == 'checked') ? 'select' : 'unselect';
1170       CRM_Core_BAO_PrevNextCache::markSelection($cacheKey, $action, $cId);
1171     }
1172     $contactIds = CRM_Core_BAO_PrevNextCache::getSelection($cacheKey);
1173     $countSelectionCids = count($contactIds[$cacheKey]);
1174
1175     $arrRet = array('getCount' => $countSelectionCids);
1176     echo json_encode($arrRet);
1177     CRM_Utils_System::civiExit();
1178   }
1179
1180   static function _convertToId($name) {
1181     if (substr($name, 0, CRM_Core_Form::CB_PREFIX_LEN) == CRM_Core_Form::CB_PREFIX) {
1182       $cId = substr($name, CRM_Core_Form::CB_PREFIX_LEN);
1183     }
1184     return $cId;
1185   }
1186
1187   static function getAddressDisplay() {
1188     $contactId = CRM_Utils_Array::value('contact_id', $_REQUEST);
1189     if (!$contactId) {
1190       $addressVal["error_message"] = "no contact id found";
1191     }
1192     else {
1193       $entityBlock =
1194         array(
1195           'contact_id' => $contactId,
1196           'entity_id' => $contactId,
1197         );
1198       $addressVal = CRM_Core_BAO_Address::getValues($entityBlock);
1199     }
1200
1201     echo json_encode($addressVal);
1202     CRM_Utils_System::civiExit();
1203   }
1204 }