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