CRM/Activity/Page/AJAX.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | CiviCRM version 4.3                                                |
   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 the function that are called using AJAX (jQuery)
  37  */
  38 class CRM_Activity_Page_AJAX {
  39   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       0 => 'display_date', 1 => 'ca.subject', 2 => 'ca.activity_type_id',
  47       3 => 'acc.sort_name', 4 => 'cc.sort_name', 5 => 'ca.status_id',
  48     );
  49
  50     $sEcho     = CRM_Utils_Type::escape($_REQUEST['sEcho'], 'Integer');
  51     $offset    = isset($_REQUEST['iDisplayStart']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayStart'], 'Integer') : 0;
  52     $rowCount  = isset($_REQUEST['iDisplayLength']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayLength'], 'Integer') : 25;
  53     $sort      = isset($_REQUEST['iSortCol_0']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_REQUEST['iSortCol_0'], 'Integer'), $sortMapper) : NULL;
  54     $sortOrder = isset($_REQUEST['sSortDir_0']) ? CRM_Utils_Type::escape($_REQUEST['sSortDir_0'], 'String') : 'asc';
  55
  56     $params = $_POST;
  57     if ($sort && $sortOrder) {
  58       $params['sortname'] = $sort;
  59       $params['sortorder'] = $sortOrder;
  60     }
  61     $params['page'] = ($offset / $rowCount) + 1;
  62     $params['rp'] = $rowCount;
  63
  64     // get the activities related to given case
  65     $activities = CRM_Case_BAO_Case::getCaseActivity($caseID, $params, $contactID, $context, $userID);
  66
  67     $iFilteredTotal = $iTotal = $params['total'];
  68     $selectorElements = array('display_date', 'subject', 'type', 'with_contacts', 'reporter', 'status', 'links', 'class');
  69
  70     echo CRM_Utils_JSON::encodeDataTableSelector($activities, $sEcho, $iTotal, $iFilteredTotal, $selectorElements);
  71     CRM_Utils_System::civiExit();
  72   }
  73
  74   static function getCaseGlobalRelationships() {
  75     $sortMapper = array(
  76       0 => 'sort_name', 1 => 'phone', 2 => 'email',
  77     );
  78
  79     $sEcho     = CRM_Utils_Type::escape($_REQUEST['sEcho'], 'Integer');
  80     $offset    = isset($_REQUEST['iDisplayStart']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayStart'], 'Integer') : 0;
  81     $rowCount  = isset($_REQUEST['iDisplayLength']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayLength'], 'Integer') : 25;
  82     $sort      = isset($_REQUEST['iSortCol_0']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_REQUEST['iSortCol_0'], 'Integer'), $sortMapper) : NULL;
  83     $sortOrder = isset($_REQUEST['sSortDir_0']) ? CRM_Utils_Type::escape($_REQUEST['sSortDir_0'], 'String') : 'asc';
  84
  85     $params = $_POST;
  86     if ($sort && $sortOrder) {
  87       $sortSQL = $sort .' '.$sortOrder;
  88     }
  89
  90     // get the activities related to given case
  91     $globalGroupInfo = array();
  92
  93     // get the total row count
  94     $relGlobalTotalCount = CRM_Case_BAO_Case::getGlobalContacts($globalGroupInfo, NULL, FALSE, TRUE, NULL, NULL);
  95     // limit the rows
  96     $relGlobal = CRM_Case_BAO_Case::getGlobalContacts($globalGroupInfo, $sortSQL, $showLinks = TRUE, FALSE, $offset, $rowCount);
  97
  98     $iFilteredTotal = $iTotal = $relGlobalTotalCount;
  99     $selectorElements = array('sort_name', 'phone', 'email');
 100
 101     echo CRM_Utils_JSON::encodeDataTableSelector($relGlobal, $sEcho, $iTotal, $iFilteredTotal, $selectorElements);
 102     CRM_Utils_System::civiExit();
 103   }
 104
 105   static function getCaseClientRelationships() {
 106     $caseID    = CRM_Utils_Type::escape($_GET['caseID'], 'Integer');
 107     $contactID = CRM_Utils_Type::escape($_GET['cid'], 'Integer');
 108
 109     $sortMapper = array(
 110       0 => 'relation', 1 => 'name', 2 => 'phone', 3 => 'email'
 111     );
 112
 113     $sEcho     = CRM_Utils_Type::escape($_REQUEST['sEcho'], 'Integer');
 114     $offset    = isset($_REQUEST['iDisplayStart']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayStart'], 'Integer') : 0;
 115     $rowCount  = isset($_REQUEST['iDisplayLength']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayLength'], 'Integer') : 25;
 116     $sort      = isset($_REQUEST['iSortCol_0']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_REQUEST['iSortCol_0'], 'Integer'), $sortMapper) : 'relation';
 117     $sortOrder = isset($_REQUEST['sSortDir_0']) ? CRM_Utils_Type::escape($_REQUEST['sSortDir_0'], 'String') : 'asc';
 118
 119     $params = $_POST;
 120     if ($sort && $sortOrder) {
 121       $sortSQL = $sort .' '.$sortOrder;
 122     }
 123
 124     // Retrieve ALL client relationships
 125     $relClient = CRM_Contact_BAO_Relationship::getRelationship($contactID,
 126       CRM_Contact_BAO_Relationship::CURRENT,
 127       0, 0, 0, NULL, NULL, FALSE
 128     );
 129
 130     $caseRelationships = CRM_Case_BAO_Case::getCaseRoles($contactID, $caseID);
 131
 132     // Now build 'Other Relationships' array by removing relationships that are already listed under Case Roles
 133     // so they don't show up twice.
 134     $clientRelationships = array();
 135     foreach ($relClient as $r) {
 136       if (!array_key_exists($r['id'], $caseRelationships)) {
 137         $clientRelationships[] = $r;
 138       }
 139     }
 140
 141     // sort clientRelationships array using jquery call params
 142     foreach ($clientRelationships as $key => $row) {
 143       $sortArray[$key]  = $row[$sort];
 144     }
 145     $sort_type = "SORT_".strtoupper($sortOrder);
 146     $sort_function = "array_multisort(\$sortArray, ".$sort_type.", \$clientRelationships);";
 147     eval($sort_function);
 148
 149     //limit the rows
 150     $allClientRelationships = $clientRelationships;
 151     $clientRelationships = array_slice($allClientRelationships, $offset, $rowCount, TRUE);
 152
 153     // after sort we can update username fields to be a url
 154     foreach($clientRelationships as $key => $value) {
 155       $clientRelationships[$key]['name'] = '<a href='.CRM_Utils_System::url('civicrm/contact/view',
 156        'action=view&reset=1&cid='.$clientRelationships[$key]['cid']).'>'.$clientRelationships[$key]['name'].'</a>';
 157     }
 158
 159     $iFilteredTotal = $iTotal = $params['total'] = count($allClientRelationships);
 160     $selectorElements = array('relation', 'name', 'phone', 'email');
 161
 162     echo CRM_Utils_JSON::encodeDataTableSelector($clientRelationships, $sEcho, $iTotal, $iFilteredTotal, $selectorElements);
 163     CRM_Utils_System::civiExit();
 164   }
 165
 166
 167   static function getCaseRoles() {
 168     $caseID    = CRM_Utils_Type::escape($_GET['caseID'], 'Integer');
 169     $contactID = CRM_Utils_Type::escape($_GET['cid'], 'Integer');
 170
 171     $sortMapper = array(
 172       0 => 'relation', 1 => 'name', 2 => 'phone', 3 => 'email', 4 => 'actions'
 173     );
 174
 175     $sEcho     = CRM_Utils_Type::escape($_REQUEST['sEcho'], 'Integer');
 176     $offset    = isset($_REQUEST['iDisplayStart']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayStart'], 'Integer') : 0;
 177     $rowCount  = isset($_REQUEST['iDisplayLength']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayLength'], 'Integer') : 25;
 178     $sort      = isset($_REQUEST['iSortCol_0']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_REQUEST['iSortCol_0'], 'Integer'), $sortMapper) : 'relation';
 179     $sortOrder = isset($_REQUEST['sSortDir_0']) ? CRM_Utils_Type::escape($_REQUEST['sSortDir_0'], 'String') : 'asc';
 180
 181     $params = $_POST;
 182     if ($sort && $sortOrder) {
 183       $sortSQL = $sort .' '.$sortOrder;
 184     }
 185
 186     $caseRelationships = CRM_Case_BAO_Case::getCaseRoles($contactID, $caseID);
 187     $caseTypeName = CRM_Case_BAO_Case::getCaseType($caseID, 'name');
 188     $xmlProcessor = new CRM_Case_XMLProcessor_Process();
 189     $caseRoles    = $xmlProcessor->get($caseTypeName, 'CaseRoles');
 190
 191     $hasAccessToAllCases = CRM_Core_Permission::check('access all cases and activities');
 192
 193     $managerRoleId = $xmlProcessor->getCaseManagerRoleId($caseTypeName);
 194     if (!empty($managerRoleId)) {
 195       $caseRoles[$managerRoleId] = $caseRoles[$managerRoleId] . '<br />' . '(' . ts('Case Manager') . ')';
 196     }
 197
 198     foreach ($caseRelationships as $key => $value) {
 199       //calculate roles that don't have relationships
 200       if (CRM_Utils_Array::value($value['relation_type'], $caseRoles)) {
 201         //keep naming from careRoles array
 202         $caseRelationships[$key]['relation'] = $caseRoles[$value['relation_type']];
 203         unset($caseRoles[$value['relation_type']]);
 204       }
 205       // mark orginal case relationships record to use on setting edit links below
 206       $caseRelationships[$key]['source'] = 'caseRel';
 207     }
 208
 209     $caseRoles['client'] = CRM_Case_BAO_Case::getContactNames($caseID);
 210
 211     // move/transform caseRoles array data to caseRelationships
 212     // for sorting and display
 213     foreach($caseRoles as $id => $value) {
 214       if ($id != "client") {
 215         $rel = array();
 216         $rel['relation'] = $value;
 217         $rel['relation_type'] = $id;
 218         $rel['name'] = '(not assigned)';
 219         $rel['phone'] = '';
 220         $rel['email'] = '';
 221         $rel['source'] = 'caseRoles';
 222         $caseRelationships[] = $rel;
 223       } else {
 224         foreach($value as $clientRole) {
 225           $relClient = array();
 226           $relClient['relation'] = 'Client';
 227           $relClient['name'] = $clientRole['sort_name'];
 228           $relClient['phone'] = $clientRole['phone'];
 229           $relClient['email'] = $clientRole['email'];
 230           $relClient['cid'] = $clientRole['contact_id'];
 231           $relClient['source'] = 'contact';
 232           $caseRelationships[] = $relClient;
 233         }
 234       }
 235     }
 236
 237     // sort clientRelationships array using jquery call params
 238     foreach ($caseRelationships as $key => $row) {
 239       $sortArray[$key]  = $row[$sort];
 240     }
 241
 242     $sort_type = "SORT_".strtoupper($sortOrder);
 243
 244     $sort_function = "array_multisort(\$sortArray, ".$sort_type.", \$caseRelationships);";
 245     eval($sort_function);
 246
 247     //limit rows display
 248     $allCaseRelationships = $caseRelationships;
 249     $caseRelationships = array_slice($allCaseRelationships, $offset, $rowCount, TRUE);
 250
 251     // set user name, email and edit columns links
 252     // idx will count number of current row / needed by edit links
 253     $idx = 1;
 254     foreach ($caseRelationships as $key => $row) {
 255       // view user links
 256       if ($caseRelationships[$key]['cid']) {
 257         $caseRelationships[$key]['name'] = '<a href='.CRM_Utils_System::url('civicrm/contact/view',
 258           'action=view&reset=1&cid='.$caseRelationships[$key]['cid']).'>'.$caseRelationships[$key]['name'].'</a>';
 259       }
 260       // email column links/icon
 261       if ($caseRelationships[$key]['email']) {
 262         $caseRelationships[$key]['email'] = '<a href="'.CRM_Utils_System::url('civicrm/contact/view/activity', 'action=reset=1&action=add&atype=3&cid='.$caseRelationships[$key]['cid']).'" title="compose and send an email"><div class="icon email-icon" title="compose and send an email"></div>
 263              </a>';
 264       }
 265       // edit links
 266       if ($hasAccessToAllCases) {
 267         switch($caseRelationships[$key]['source']){
 268         case 'caseRel':
 269           $caseRelationships[$key]['actions'] =
 270             '<a href="#" title="edit case role" onclick="createRelationship( '.$caseRelationships[$key]['relation_type'].', '.$caseRelationships[$key]['cid'].', '.$caseRelationships[$key]['rel_id'].', '.$idx.', \''.$caseRelationships[$key]['relation'].'\' );return false;"><div class="icon edit-icon" ></div></a>&nbsp;&nbsp;<a href="#" class="case-role-delete" case_id="'.$caseID.'" rel_type="'.$caseRelationships[$key]['relation_type'].'"><div class="icon delete-icon" title="remove contact from case role"></div></a>';
 271           break;
 272
 273         case 'caseRoles':
 274           $caseRelationships[$key]['actions'] =
 275             '<a href="#" title="edit case role" onclick="createRelationship('.$caseRelationships[$key]['relation_type'].', null, null, '.$idx.',  \''.$caseRelationships[$key]['relation'].'\');return false;"><div class="icon edit-icon"></div></a>';
 276           break;
 277         }
 278       } else {
 279         $caseRelationships[$key]['actions'] = '';
 280       }
 281       $idx++;
 282     }
 283     $iFilteredTotal = $iTotal = $params['total'] = count($allCaseRelationships);
 284     $selectorElements = array('relation', 'name', 'phone', 'email', 'actions');
 285
 286     echo CRM_Utils_JSON::encodeDataTableSelector($caseRelationships, $sEcho, $iTotal, $iFilteredTotal, $selectorElements);
 287     CRM_Utils_System::civiExit();
 288   }
 289
 290   static function convertToCaseActivity() {
 291     $params = array('caseID', 'activityID', 'contactID', 'newSubject', 'targetContactIds', 'mode');
 292     foreach ($params as $param) {
 293       $vals[$param] = CRM_Utils_Array::value($param, $_POST);
 294     }
 295
 296     $retval = self::_convertToCaseActivity($vals);
 297
 298     echo json_encode($retval);
 299     CRM_Utils_System::civiExit();
 300   }
 301
 302   static function _convertToCaseActivity($params) {
 303     if (!$params['activityID'] || !$params['caseID']) {
 304       return (array('error_msg' => 'required params missing.'));
 305     }
 306
 307     $otherActivity = new CRM_Activity_DAO_Activity();
 308     $otherActivity->id = $params['activityID'];
 309     if (!$otherActivity->find(TRUE)) {
 310       return (array('error_msg' => 'activity record is missing.'));
 311     }
 312     $actDateTime = CRM_Utils_Date::isoToMysql($otherActivity->activity_date_time);
 313
 314     //create new activity record.
 315     $mainActivity = new CRM_Activity_DAO_Activity();
 316     $mainActVals = array();
 317     CRM_Core_DAO::storeValues($otherActivity, $mainActVals);
 318
 319     //get new activity subject.
 320     if (!empty($params['newSubject'])) {
 321       $mainActVals['subject'] = $params['newSubject'];
 322     }
 323
 324     $mainActivity->copyValues($mainActVals);
 325     $mainActivity->id = NULL;
 326     $mainActivity->activity_date_time = $actDateTime;
 327     //make sure this is current revision.
 328     $mainActivity->is_current_revision = TRUE;
 329     //drop all relations.
 330     $mainActivity->parent_id = $mainActivity->original_id = NULL;
 331
 332     $mainActivity->save();
 333     $mainActivityId = $mainActivity->id;
 334     CRM_Activity_BAO_Activity::logActivityAction($mainActivity);
 335     $mainActivity->free();
 336
 337     /* Mark previous activity as deleted. If it was a non-case activity
 338          * then just change the subject.
 339          */
 340
 341     if (in_array($params['mode'], array(
 342       'move', 'file'))) {
 343       $caseActivity = new CRM_Case_DAO_CaseActivity();
 344       $caseActivity->case_id = $params['caseID'];
 345       $caseActivity->activity_id = $otherActivity->id;
 346       if ($params['mode'] == 'move' || $caseActivity->find(TRUE)) {
 347         $otherActivity->is_deleted = 1;
 348       }
 349       else {
 350         $otherActivity->subject = ts('(Filed on case %1)', array(
 351           1 => $params['caseID'])) . ' ' . $otherActivity->subject;
 352       }
 353       $otherActivity->activity_date_time = $actDateTime;
 354       $otherActivity->save();
 355
 356       $caseActivity->free();
 357     }
 358     $otherActivity->free();
 359
 360     $targetContacts = array();
 361     if (!empty($params['targetContactIds'])) {
 362       $targetContacts = array_unique(explode(',', $params['targetContactIds']));
 363     }
 364     foreach ($targetContacts as $key => $value) {
 365       $targ_params = array(
 366         'activity_id' => $mainActivityId,
 367         'target_contact_id' => $value,
 368       );
 369       CRM_Activity_BAO_Activity::createActivityTarget($targ_params);
 370     }
 371
 372     // typically this will be empty, since assignees on another case may be completely different
 373     $assigneeContacts = array();
 374     if (!empty($params['assigneeContactIds'])) {
 375       $assigneeContacts = array_unique(explode(',', $params['assigneeContactIds']));
 376     }
 377     foreach ($assigneeContacts as $key => $value) {
 378       $assigneeParams = array(
 379         'activity_id' => $mainActivityId,
 380         'assignee_contact_id' => $value,
 381       );
 382       CRM_Activity_BAO_Activity::createActivityAssignment($assigneeParams);
 383     }
 384
 385     //attach newly created activity to case.
 386     $caseActivity = new CRM_Case_DAO_CaseActivity();
 387     $caseActivity->case_id = $params['caseID'];
 388     $caseActivity->activity_id = $mainActivityId;
 389     $caseActivity->save();
 390     $error_msg = $caseActivity->_lastError;
 391     $caseActivity->free();
 392
 393     $params['mainActivityId'] = $mainActivityId;
 394     CRM_Activity_BAO_Activity::copyExtendedActivityData($params);
 395
 396     return (array('error_msg' => $error_msg, 'newId' => $mainActivity->id));
 397   }
 398
 399   static function getContactActivity() {
 400     $contactID = CRM_Utils_Type::escape($_POST['contact_id'], 'Integer');
 401     $context = CRM_Utils_Type::escape(CRM_Utils_Array::value('context', $_GET), 'String');
 402
 403     $sortMapper = array(
 404       0 => 'activity_type', 1 => 'subject', 2 => 'source_contact_name',
 405       3 => '', 4 => '', 5 => 'activity_date_time', 6 => 'status_id',
 406     );
 407
 408     $sEcho     = CRM_Utils_Type::escape($_REQUEST['sEcho'], 'Integer');
 409     $offset    = isset($_REQUEST['iDisplayStart']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayStart'], 'Integer') : 0;
 410     $rowCount  = isset($_REQUEST['iDisplayLength']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayLength'], 'Integer') : 25;
 411     $sort      = isset($_REQUEST['iSortCol_0']) ? CRM_Utils_Array::value(CRM_Utils_Type::escape($_REQUEST['iSortCol_0'], 'Integer'), $sortMapper) : NULL;
 412     $sortOrder = isset($_REQUEST['sSortDir_0']) ? CRM_Utils_Type::escape($_REQUEST['sSortDir_0'], 'String') : 'asc';
 413
 414     $params = $_POST;
 415     if ($sort && $sortOrder) {
 416       $params['sortBy'] = $sort . ' ' . $sortOrder;
 417     }
 418
 419     $params['page'] = ($offset / $rowCount) + 1;
 420     $params['rp'] = $rowCount;
 421
 422     $params['contact_id'] = $contactID;
 423     $params['context'] = $context;
 424
 425     // get the contact activities
 426     $activities = CRM_Activity_BAO_Activity::getContactActivitySelector($params);
 427
 428     // store the activity filter preference CRM-11761
 429     $session = CRM_Core_Session::singleton();
 430     $userID = $session->get('userID');
 431     if ($userID) {
 432       $activityFilter =
 433         array('activity_type_filter_id' => CRM_Utils_Array::value('activity_type_id', $params),
 434               'activity_type_exclude_filter_id' => CRM_Utils_Array::value('activity_type_exclude_id', $params));
 435               CRM_Core_BAO_Setting::setItem($activityFilter,
 436                                             CRM_Core_BAO_Setting::PERSONAL_PREFERENCES_NAME,
 437                                             'activity_tab_filter',
 438                                             NULL,
 439                                             $userID,
 440                                             $userID
 441                                     );
 442     }
 443
 444     $iFilteredTotal = $iTotal = $params['total'];
 445     $selectorElements = array(
 446       'activity_type', 'subject', 'source_contact',
 447       'target_contact', 'assignee_contact',
 448       'activity_date', 'status', 'openstats','links', 'class',
 449     );
 450
 451     echo CRM_Utils_JSON::encodeDataTableSelector($activities, $sEcho, $iTotal, $iFilteredTotal, $selectorElements);
 452     CRM_Utils_System::civiExit();
 453   }
 454 }
 455