Merge remote-tracking branch 'upstream/4.6' into 4.6-master-2015-06-08-21-41-06
[civicrm-core.git] / CRM / Activity / Page / AJAX.php
1 <?php
2 /*
3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.6 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2015 |
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-2015
32 *
33 */
34
35 /**
36 * This class contains all the function that are called using AJAX (jQuery)
37 */
38 class CRM_Activity_Page_AJAX {
39 public static function getCaseActivity() {
40 $caseID = CRM_Utils_Type::escape($_GET['caseID'], 'Integer');
41 $contactID = CRM_Utils_Type::escape($_GET['cid'], 'Integer');
42 $userID = CRM_Utils_Type::escape($_GET['userID'], 'Integer');
43 $context = CRM_Utils_Type::escape(CRM_Utils_Array::value('context', $_GET), 'String');
44
45 $sortMapper = array();
46 foreach ($_GET['columns'] as $key => $value) {
47 $sortMapper[$key] = $value['data'];
48 };
49
50 $offset = isset($_GET['start']) ? CRM_Utils_Type::escape($_GET['start'], 'Integer') : 0;
51 $rowCount = isset($_GET['length']) ? CRM_Utils_Type::escape($_GET['length'], 'Integer') : 25;
52 $sort = isset($_GET['order'][0]['column']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_GET['order'][0]['column'], 'Integer'), $sortMapper) : NULL;
53 $sortOrder = isset($_GET['order'][0]['dir']) ? CRM_Utils_Type::escape($_GET['order'][0]['dir'], 'String') : 'asc';
54
55 $params = $_GET;
56 if ($sort && $sortOrder) {
57 $params['sortBy'] = $sort . ' ' . $sortOrder;
58 }
59 $params['page'] = ($offset / $rowCount) + 1;
60 $params['rp'] = $rowCount;
61
62 // get the activities related to given case
63 $activities = CRM_Case_BAO_Case::getCaseActivity($caseID, $params, $contactID, $context, $userID);
64
65 CRM_Utils_JSON::output($activities);
66 }
67
68 public static function getCaseGlobalRelationships() {
69 $sortMapper = array();
70 foreach ($_GET['columns'] as $key => $value) {
71 $sortMapper[$key] = $value['data'];
72 };
73
74 $offset = isset($_GET['start']) ? CRM_Utils_Type::escape($_GET['start'], 'Integer') : 0;
75 $rowCount = isset($_GET['length']) ? CRM_Utils_Type::escape($_GET['length'], 'Integer') : 25;
76 $sort = isset($_GET['order'][0]['column']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_GET['order'][0]['column'], 'Integer'), $sortMapper) : NULL;
77 $sortOrder = isset($_GET['order'][0]['dir']) ? CRM_Utils_Type::escape($_GET['order'][0]['dir'], 'String') : 'asc';
78
79 $params = $_GET;
80
81 //CRM-14466 initialize variable to avoid php notice
82 $sortSQL = "";
83 if ($sort && $sortOrder) {
84 $sortSQL = $sort . ' ' . $sortOrder;
85 }
86
87 // get the activities related to given case
88 $globalGroupInfo = array();
89
90 // get the total row count
91 $relGlobalTotalCount = CRM_Case_BAO_Case::getGlobalContacts($globalGroupInfo, NULL, FALSE, TRUE, NULL, NULL);
92 // limit the rows
93 $relGlobal = CRM_Case_BAO_Case::getGlobalContacts($globalGroupInfo, $sortSQL, $showLinks = TRUE, FALSE, $offset, $rowCount);
94
95 $relationships = array();
96 // after sort we can update username fields to be a url
97 foreach ($relGlobal as $key => $value) {
98 $relationship = array();
99 $relationship['sort_name'] = $value['sort_name'];
100 $relationship['phone'] = $value['phone'];
101 $relationship['email'] = $value['email'];
102
103 array_push($relationships, $relationship);
104 }
105
106 $params['total'] = count($relationships);
107
108 $globalRelationshipsDT = array();
109 $globalRelationshipsDT['data'] = $relationships;
110 $globalRelationshipsDT['recordsTotal'] = $params['total'];
111 $globalRelationshipsDT['recordsFiltered'] = $params['total'];
112
113 CRM_Utils_JSON::output($globalRelationshipsDT);
114 }
115
116 public static function getCaseClientRelationships() {
117 $caseID = CRM_Utils_Type::escape($_GET['caseID'], 'Integer');
118 $contactID = CRM_Utils_Type::escape($_GET['cid'], 'Integer');
119
120 $sortMapper = array();
121 foreach ($_GET['columns'] as $key => $value) {
122 $sortMapper[$key] = $value['data'];
123 };
124
125 $offset = isset($_GET['start']) ? CRM_Utils_Type::escape($_GET['start'], 'Integer') : 0;
126 $rowCount = isset($_GET['length']) ? CRM_Utils_Type::escape($_GET['length'], 'Integer') : 25;
127 $sort = isset($_GET['order'][0]['column']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_GET['order'][0]['column'], 'Integer'), $sortMapper) : NULL;
128 $sortOrder = isset($_GET['order'][0]['dir']) ? CRM_Utils_Type::escape($_GET['order'][0]['dir'], 'String') : 'asc';
129
130 $params = $_GET;
131
132 // Retrieve ALL client relationships
133 $relClient = CRM_Contact_BAO_Relationship::getRelationship($contactID,
134 CRM_Contact_BAO_Relationship::CURRENT,
135 0, 0, 0, NULL, NULL, FALSE
136 );
137
138 $caseRelationships = CRM_Case_BAO_Case::getCaseRoles($contactID, $caseID);
139
140 // Now build 'Other Relationships' array by removing relationships that are already listed under Case Roles
141 // so they don't show up twice.
142 $clientRelationships = array();
143 foreach ($relClient as $r) {
144 if (!array_key_exists($r['id'], $caseRelationships)) {
145 $clientRelationships[] = $r;
146 }
147 }
148
149 // sort clientRelationships array using jquery call params
150 foreach ($clientRelationships as $key => $row) {
151 $sortArray[$key] = $row[$sort];
152 }
153 $sort_type = "SORT_" . strtoupper($sortOrder);
154 array_multisort($sortArray, constant($sort_type), $clientRelationships);
155
156 $relationships = array();
157 // after sort we can update username fields to be a url
158 foreach ($clientRelationships as $key => $value) {
159 $relationship = array();
160 $relationship['relation'] = $value['relation'];
161 $relationship['name'] = '<a href=' . CRM_Utils_System::url('civicrm/contact/view',
162 'action=view&reset=1&cid=' . $clientRelationships[$key]['cid']) . '>' . $clientRelationships[$key]['name'] . '</a>';
163 $relationship['phone'] = $value['phone'];
164 $relationship['email'] = $value['email'];
165
166 array_push($relationships, $relationship);
167 }
168
169 $params['total'] = count($relationships);
170
171 $clientRelationshipsDT = array();
172 $clientRelationshipsDT['data'] = $relationships;
173 $clientRelationshipsDT['recordsTotal'] = $params['total'];
174 $clientRelationshipsDT['recordsFiltered'] = $params['total'];
175
176 CRM_Utils_JSON::output($clientRelationshipsDT);
177 }
178
179
180 public static function getCaseRoles() {
181 $caseID = CRM_Utils_Type::escape($_GET['caseID'], 'Integer');
182 $contactID = CRM_Utils_Type::escape($_GET['cid'], 'Integer');
183
184 $sortMapper = array();
185 foreach ($_GET['columns'] as $key => $value) {
186 $sortMapper[$key] = $value['data'];
187 };
188
189 $offset = isset($_GET['start']) ? CRM_Utils_Type::escape($_GET['start'], 'Integer') : 0;
190 $rowCount = isset($_GET['length']) ? CRM_Utils_Type::escape($_GET['length'], 'Integer') : 25;
191 $sort = isset($_GET['order'][0]['column']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_GET['order'][0]['column'], 'Integer'), $sortMapper) : NULL;
192 $sortOrder = isset($_GET['order'][0]['dir']) ? CRM_Utils_Type::escape($_GET['order'][0]['dir'], 'String') : 'asc';
193
194 $params = $_GET;
195
196 $caseRelationships = CRM_Case_BAO_Case::getCaseRoles($contactID, $caseID);
197 $caseTypeName = CRM_Case_BAO_Case::getCaseType($caseID, 'name');
198 $xmlProcessor = new CRM_Case_XMLProcessor_Process();
199 $caseRoles = $xmlProcessor->get($caseTypeName, 'CaseRoles');
200
201 $hasAccessToAllCases = CRM_Core_Permission::check('access all cases and activities');
202
203 $managerRoleId = $xmlProcessor->getCaseManagerRoleId($caseTypeName);
204 if (!empty($managerRoleId)) {
205 $caseRoles[$managerRoleId] = $caseRoles[$managerRoleId] . '<br />' . '(' . ts('Case Manager') . ')';
206 }
207
208 $relationships = array();
209
210 foreach ($caseRelationships as $key => $value) {
211 //calculate roles that don't have relationships
212 if (!empty($caseRoles[$value['relation_type']])) {
213 //keep naming from careRoles array
214 $caseRelationships[$key]['relation'] = $caseRoles[$value['relation_type']];
215 unset($caseRoles[$value['relation_type']]);
216 }
217 // mark original case relationships record to use on setting edit links below
218 $caseRelationships[$key]['source'] = 'caseRel';
219 }
220
221 $caseRoles['client'] = CRM_Case_BAO_Case::getContactNames($caseID);
222
223 // move/transform caseRoles array data to caseRelationships
224 // for sorting and display
225 // CRM-14466 added cid to the non-client array to avoid php notice
226 foreach ($caseRoles as $id => $value) {
227 if ($id != "client") {
228 $rel = array();
229 $rel['relation'] = $value;
230 $rel['relation_type'] = $id;
231 $rel['name'] = '(not assigned)';
232 $rel['phone'] = '';
233 $rel['email'] = '';
234 $rel['source'] = 'caseRoles';
235 $caseRelationships[] = $rel;
236 }
237 else {
238 foreach ($value as $clientRole) {
239 $relClient = array();
240 $relClient['relation'] = 'Client';
241 $relClient['name'] = $clientRole['sort_name'];
242 $relClient['phone'] = $clientRole['phone'];
243 $relClient['email'] = $clientRole['email'];
244 $relClient['cid'] = $clientRole['contact_id'];
245 $relClient['source'] = 'contact';
246 $caseRelationships[] = $relClient;
247 }
248 }
249 }
250
251 // sort clientRelationships array using jquery call params
252 foreach ($caseRelationships as $key => $row) {
253 $sortArray[$key] = $row[$sort];
254 }
255 $sort_type = "SORT_" . strtoupper($sortOrder);
256 array_multisort($sortArray, constant($sort_type), $caseRelationships);
257
258 $relationships = array();
259
260 // set user name, email and edit columns links
261 foreach ($caseRelationships as $key => &$row) {
262 // Get rid of the "<br />(Case Manager)" from label
263 list($typeLabel) = explode('<', $row['relation']);
264 // view user links
265 if (!empty($row['cid'])) {
266 $row['name'] = '<a class="view-contact" title="' . ts('View Contact') . '" href=' . CRM_Utils_System::url('civicrm/contact/view',
267 'action=view&reset=1&cid=' . $row['cid']) . '>' . $row['name'] . '</a>';
268 }
269 // email column links/icon
270 if ($row['email']) {
271 $row['email'] = '<a class="crm-hover-button crm-popup" href="' . CRM_Utils_System::url('civicrm/activity/email/add', 'reset=1&action=add&atype=3&cid=' . $row['cid']) . '&caseid=' . $caseID . '" title="' . ts('Send an Email') . '"><span class="icon ui-icon-mail-closed"></span></a>';
272 }
273 // edit links
274 $row['actions'] = '';
275 if ($hasAccessToAllCases) {
276 $contactType = empty($row['relation_type']) ? '' : (string) CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_RelationshipType', $row['relation_type'], 'contact_type_b');
277 $contactType = $contactType == 'Contact' ? '' : $contactType;
278 switch ($row['source']) {
279 case 'caseRel':
280 $row['actions'] = '<a href="#editCaseRoleDialog" title="' . ts('Reassign %1', array(1 => $typeLabel)) . '" class="crm-hover-button case-miniform" data-contact_type="' . $contactType . '" data-rel_type="' . $row['relation_type'] . '" data-rel_id="' . $row['rel_id'] . '"data-key="' . CRM_Core_Key::get('civicrm/ajax/relation') . '">' .
281 '<span class="icon ui-icon-pencil"></span>' .
282 '</a>' .
283 '<a href="#deleteCaseRoleDialog" title="' . ts('Remove %1', array(1 => $typeLabel)) . '" class="crm-hover-button case-miniform" data-contact_type="' . $contactType . '" data-rel_type="' . $row['relation_type'] . '" data-key="' . CRM_Core_Key::get('civicrm/ajax/delcaserole') . '">' .
284 '<span class="icon delete-icon"></span>' .
285 '</a>';
286 break;
287
288 case 'caseRoles':
289 $row['actions'] = '<a href="#editCaseRoleDialog" title="' . ts('Assign %1', array(1 => $typeLabel)) . '" class="crm-hover-button case-miniform" data-contact_type="' . $contactType . '" data-rel_type="' . $row['relation_type'] . '" data-key="' . CRM_Core_Key::get('civicrm/ajax/relation') . '">' .
290 '<span class="icon ui-icon-pencil"></span>' .
291 '</a>';
292 break;
293 }
294 }
295 unset($row['cid']);
296 unset($row['relation_type']);
297 unset($row['rel_id']);
298 unset($row['client_id']);
299 unset($row['source']);
300 array_push($relationships, $row);
301 }
302 $params['total'] = count($relationships);
303
304 $caseRelationshipsDT = array();
305 $caseRelationshipsDT['data'] = $relationships;
306 $caseRelationshipsDT['recordsTotal'] = $params['total'];
307 $caseRelationshipsDT['recordsFiltered'] = $params['total'];
308
309 CRM_Utils_JSON::output($caseRelationshipsDT);
310
311 }
312
313 public static function convertToCaseActivity() {
314 $params = array('caseID', 'activityID', 'contactID', 'newSubject', 'targetContactIds', 'mode');
315 $vals = array();
316 foreach ($params as $param) {
317 $vals[$param] = CRM_Utils_Array::value($param, $_POST);
318 }
319
320 CRM_Utils_JSON::output(self::_convertToCaseActivity($vals));
321 }
322
323 /**
324 * @param array $params
325 *
326 * @return array
327 */
328 public static function _convertToCaseActivity($params) {
329 if (!$params['activityID'] || !$params['caseID']) {
330 return (array('error_msg' => 'required params missing.'));
331 }
332
333 $otherActivity = new CRM_Activity_DAO_Activity();
334 $otherActivity->id = $params['activityID'];
335 if (!$otherActivity->find(TRUE)) {
336 return (array('error_msg' => 'activity record is missing.'));
337 }
338 $actDateTime = CRM_Utils_Date::isoToMysql($otherActivity->activity_date_time);
339
340 //create new activity record.
341 $mainActivity = new CRM_Activity_DAO_Activity();
342 $mainActVals = array();
343 CRM_Core_DAO::storeValues($otherActivity, $mainActVals);
344
345 //get new activity subject.
346 if (!empty($params['newSubject'])) {
347 $mainActVals['subject'] = $params['newSubject'];
348 }
349
350 $mainActivity->copyValues($mainActVals);
351 $mainActivity->id = NULL;
352 $mainActivity->activity_date_time = $actDateTime;
353 //make sure this is current revision.
354 $mainActivity->is_current_revision = TRUE;
355 //drop all relations.
356 $mainActivity->parent_id = $mainActivity->original_id = NULL;
357
358 $mainActivity->save();
359 $mainActivityId = $mainActivity->id;
360 CRM_Activity_BAO_Activity::logActivityAction($mainActivity);
361 $mainActivity->free();
362
363 /* Mark previous activity as deleted. If it was a non-case activity
364 * then just change the subject.
365 */
366
367 if (in_array($params['mode'], array(
368 'move',
369 'file',
370 ))) {
371 $caseActivity = new CRM_Case_DAO_CaseActivity();
372 $caseActivity->case_id = $params['caseID'];
373 $caseActivity->activity_id = $otherActivity->id;
374 if ($params['mode'] == 'move' || $caseActivity->find(TRUE)) {
375 $otherActivity->is_deleted = 1;
376 }
377 else {
378 $otherActivity->subject = ts('(Filed on case %1)', array(
379 1 => $params['caseID'],
380 )) . ' ' . $otherActivity->subject;
381 }
382 $otherActivity->activity_date_time = $actDateTime;
383 $otherActivity->save();
384
385 $caseActivity->free();
386 }
387 $otherActivity->free();
388
389 $targetContacts = array();
390 if (!empty($params['targetContactIds'])) {
391 $targetContacts = array_unique(explode(',', $params['targetContactIds']));
392 }
393
394 $activityContacts = CRM_Core_OptionGroup::values('activity_contacts', FALSE, FALSE, FALSE, NULL, 'name');
395 $sourceID = CRM_Utils_Array::key('Activity Source', $activityContacts);
396 $assigneeID = CRM_Utils_Array::key('Activity Assignees', $activityContacts);
397 $targetID = CRM_Utils_Array::key('Activity Targets', $activityContacts);
398
399 $sourceContactID = CRM_Activity_BAO_Activity::getSourceContactID($params['activityID']);
400 $src_params = array(
401 'activity_id' => $mainActivityId,
402 'contact_id' => $sourceContactID,
403 'record_type_id' => $sourceID,
404 );
405 CRM_Activity_BAO_ActivityContact::create($src_params);
406
407 foreach ($targetContacts as $key => $value) {
408 $targ_params = array(
409 'activity_id' => $mainActivityId,
410 'contact_id' => $value,
411 'record_type_id' => $targetID,
412 );
413 CRM_Activity_BAO_ActivityContact::create($targ_params);
414 }
415
416 // typically this will be empty, since assignees on another case may be completely different
417 $assigneeContacts = array();
418 if (!empty($params['assigneeContactIds'])) {
419 $assigneeContacts = array_unique(explode(',', $params['assigneeContactIds']));
420 }
421 foreach ($assigneeContacts as $key => $value) {
422 $assigneeParams = array(
423 'activity_id' => $mainActivityId,
424 'contact_id' => $value,
425 'record_type_id' => $assigneeID,
426 );
427 CRM_Activity_BAO_ActivityContact::create($assigneeParams);
428 }
429
430 //attach newly created activity to case.
431 $caseActivity = new CRM_Case_DAO_CaseActivity();
432 $caseActivity->case_id = $params['caseID'];
433 $caseActivity->activity_id = $mainActivityId;
434 $caseActivity->save();
435 $error_msg = $caseActivity->_lastError;
436 $caseActivity->free();
437
438 $params['mainActivityId'] = $mainActivityId;
439 CRM_Activity_BAO_Activity::copyExtendedActivityData($params);
440
441 return (array('error_msg' => $error_msg, 'newId' => $mainActivity->id));
442 }
443
444 public static function getContactActivity() {
445 $contactID = CRM_Utils_Type::escape($_GET['cid'], 'Integer');
446 $context = CRM_Utils_Type::escape(CRM_Utils_Array::value('context', $_GET), 'String');
447
448 $sortMapper = array();
449 foreach ($_GET['columns'] as $key => $value) {
450 $sortMapper[$key] = $value['data'];
451 };
452
453 $offset = isset($_GET['start']) ? CRM_Utils_Type::escape($_GET['start'], 'Integer') : 0;
454 $rowCount = isset($_GET['length']) ? CRM_Utils_Type::escape($_GET['length'], 'Integer') : 25;
455 $sort = isset($_GET['order'][0]['column']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_GET['order'][0]['column'], 'Integer'), $sortMapper) : NULL;
456 $sortOrder = isset($_GET['order'][0]['dir']) ? CRM_Utils_Type::escape($_GET['order'][0]['dir'], 'String') : 'asc';
457
458 $params = $_GET;
459 if ($sort && $sortOrder) {
460 $params['sortBy'] = $sort . ' ' . $sortOrder;
461 }
462
463 $params['page'] = ($offset / $rowCount) + 1;
464 $params['rp'] = $rowCount;
465
466 $params['contact_id'] = $contactID;
467 $params['context'] = $context;
468
469 // get the contact activities
470 $activities = CRM_Activity_BAO_Activity::getContactActivitySelector($params);
471
472 foreach ($activities as $key => $value) {
473 //Check if recurring activity
474 if (!empty($value['is_recurring_activity'])) {
475 $repeat = $value['is_recurring_activity'];
476 $activities[$key]['activity_type'] .= '<br/><span class="bold">' . ts('Repeating (%1 of %2)', array(1 => $repeat[0], 2 => $repeat[1])) . '</span>';
477 }
478 }
479
480 // store the activity filter preference CRM-11761
481 $session = CRM_Core_Session::singleton();
482 $userID = $session->get('userID');
483 if ($userID) {
484 //flush cache before setting filter to account for global cache (memcache)
485 $domainID = CRM_Core_Config::domainID();
486 $cacheKey = CRM_Core_BAO_Setting::inCache(
487 CRM_Core_BAO_Setting::PERSONAL_PREFERENCES_NAME,
488 'activity_tab_filter',
489 NULL,
490 $userID,
491 TRUE,
492 $domainID,
493 TRUE
494 );
495 if ($cacheKey) {
496 CRM_Core_BAO_Setting::flushCache($cacheKey);
497 }
498
499 $activityFilter = array(
500 'activity_type_filter_id' => empty($params['activity_type_id']) ? '' : CRM_Utils_Type::escape($params['activity_type_id'], 'Integer'),
501 'activity_type_exclude_filter_id' => empty($params['activity_type_exclude_id']) ? '' : CRM_Utils_Type::escape($params['activity_type_exclude_id'], 'Integer'),
502 );
503
504 CRM_Core_BAO_Setting::setItem(
505 $activityFilter,
506 CRM_Core_BAO_Setting::PERSONAL_PREFERENCES_NAME,
507 'activity_tab_filter',
508 NULL,
509 $userID,
510 $userID
511 );
512 }
513
514 CRM_Utils_JSON::output($activities);
515 }
516
517 }