CRM/Case/Page/AJAX.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | CiviCRM version 4.6                                                |
   5  +--------------------------------------------------------------------+
   6  | Copyright CiviCRM LLC (c) 2004-2014                                |
   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-2014
  32  *
  33  */
  34
  35 /**
  36  * This class contains all case related functions that are called using AJAX (jQuery)
  37  */
  38 class CRM_Case_Page_AJAX {
  39
  40   /**
  41    * Retrieve unclosed cases.
  42    */
  43   public static function unclosedCases() {
  44     $params = array(
  45       'limit' => CRM_Core_BAO_Setting::getItem(CRM_Core_BAO_Setting::SYSTEM_PREFERENCES_NAME, 'search_autocomplete_count', NULL, 10),
  46       'sort_name' => CRM_Utils_Type::escape(CRM_Utils_Array::value('term', $_GET, ''), 'String'),
  47     );
  48
  49     $excludeCaseIds = array();
  50     if (!empty($_GET['excludeCaseIds'])) {
  51       $excludeCaseIds = explode(',', CRM_Utils_Type::escape($_GET['excludeCaseIds'], 'String'));
  52     }
  53     $unclosedCases = CRM_Case_BAO_Case::getUnclosedCases($params, $excludeCaseIds, TRUE, TRUE);
  54     $results = array();
  55     foreach ($unclosedCases as $caseId => $details) {
  56       $results[] = array(
  57         'id' => $caseId,
  58         'label' => $details['sort_name'] . ' - ' . $details['case_type'] . ($details['end_date'] ? ' (' . ts('closed') . ')' : ''),
  59         'label_class' => $details['end_date'] ? 'strikethrough' : '',
  60         'description' => array($details['case_subject'] . ' (' . $details['case_status'] . ')'),
  61         'extra' => $details,
  62       );
  63     }
  64     CRM_Utils_JSON::output($results);
  65   }
  66
  67   public function processCaseTags() {
  68
  69     $caseId = CRM_Utils_Type::escape($_POST['case_id'], 'Positive');
  70     $tags = CRM_Utils_Type::escape($_POST['tag'], 'String');
  71     $tagList = $_POST['taglist'];
  72
  73     if (!CRM_Case_BAO_Case::accessCase($caseId)) {
  74       CRM_Utils_System::permissionDenied();
  75     }
  76
  77     $tagIds = array();
  78     if ($tags) {
  79       $tagIds = explode(',', $tags);
  80     }
  81
  82     if (!empty($tagIds)) {
  83       $params = array(
  84         'entity_id' => $caseId,
  85         'entity_table' => 'civicrm_case',
  86       );
  87
  88       CRM_Core_BAO_EntityTag::del($params);
  89
  90       foreach ($tagIds as $tagid) {
  91         if (is_numeric($tagid)) {
  92           $params['tag_id'] = $tagid;
  93           CRM_Core_BAO_EntityTag::add($params);
  94         }
  95       }
  96     }
  97
  98     if (!empty($tagList)) {
  99       CRM_Core_Form_Tag::postProcess($tagList, $caseId, 'civicrm_case', CRM_Core_DAO::$_nullObject);
 100     }
 101
 102     $session = CRM_Core_Session::singleton();
 103
 104     $activityParams = array();
 105     $activityParams['source_contact_id'] = $session->get('userID');
 106     $activityParams['activity_type_id'] = CRM_Core_OptionGroup::getValue('activity_type', 'Change Case Tags', 'name');
 107     $activityParams['activity_date_time'] = date('YmdHis');
 108     $activityParams['status_id'] = CRM_Core_OptionGroup::getValue('activity_status', 'Completed', 'name');
 109     $activityParams['case_id'] = $caseId;
 110     $activityParams['is_auto'] = 0;
 111     $activityParams['subject'] = 'Change Case Tags';
 112
 113     $activity = CRM_Activity_BAO_Activity::create($activityParams);
 114
 115     $caseParams = array(
 116       'activity_id' => $activity->id,
 117       'case_id' => $caseId,
 118     );
 119
 120     CRM_Case_BAO_Case::processCaseActivity($caseParams);
 121
 122     echo 'true';
 123     CRM_Utils_System::civiExit();
 124   }
 125
 126   public function caseDetails() {
 127     $caseId = CRM_Utils_Type::escape($_GET['caseId'], 'Positive');
 128
 129     if (!CRM_Case_BAO_Case::accessCase($caseId, FALSE)) {
 130       CRM_Utils_System::permissionDenied();
 131     }
 132
 133     $sql       = "SELECT civicrm_case.*, civicrm_case_type.title as case_type
 134         FROM civicrm_case
 135         INNER JOIN civicrm_case_type ON civicrm_case.case_type_id = civicrm_case_type.id
 136         WHERE civicrm_case.id = %1";
 137     $dao       = CRM_Core_DAO::executeQuery($sql, array(1 => array($caseId, 'Integer')));
 138
 139     if ($dao->fetch()) {
 140       $caseStatuses = CRM_Case_PseudoConstant::caseStatus();
 141       $cs           = $caseStatuses[$dao->status_id];
 142       $caseDetails  = "<table><tr><td>" . ts('Case Subject') . "</td><td>{$dao->subject}</td></tr>
 143                                     <tr><td>" . ts('Case Type') . "</td><td>{$dao->case_type}</td></tr>
 144                                     <tr><td>" . ts('Case Status') . "</td><td>{$cs}</td></tr>
 145                                     <tr><td>" . ts('Case Start Date') . "</td><td>" . CRM_Utils_Date::customFormat($dao->start_date) . "</td></tr>
 146                                     <tr><td>" . ts('Case End Date') . "</td><td></td></tr>" . CRM_Utils_Date::customFormat($dao->end_date) . "</table>";
 147       if (CRM_Utils_Array::value('snippet', $_GET) == 'json') {
 148         CRM_Core_Page_AJAX::returnJsonResponse($caseDetails);
 149       }
 150       else {
 151         echo $caseDetails;
 152       }
 153     }
 154     else {
 155       CRM_Core_Error::fatal('Could not find valid Case.');
 156     }
 157     CRM_Utils_System::civiExit();
 158   }
 159
 160   public function addClient() {
 161     $caseId = CRM_Utils_Type::escape($_POST['caseID'], 'Positive');
 162     $contactId = CRM_Utils_Type::escape($_POST['contactID'], 'Positive');
 163
 164     if (!$contactId || !CRM_Case_BAO_Case::accessCase($caseId)) {
 165       CRM_Utils_System::permissionDenied();
 166     }
 167
 168     $params = array(
 169       'case_id' => $caseId,
 170       'contact_id' => $contactId,
 171     );
 172
 173     CRM_Case_BAO_Case::addCaseToContact($params);
 174
 175     // add case relationships
 176     CRM_Case_BAO_Case::addCaseRelationships($caseId, $contactId);
 177
 178     $session = CRM_Core_Session::singleton();
 179
 180     $activityParams = array();
 181     $activityParams['source_contact_id'] = $session->get('userID');
 182     $activityParams['activity_type_id'] = CRM_Core_OptionGroup::getValue('activity_type', 'Add Client To Case', 'name');
 183     $activityParams['activity_date_time'] = date('YmdHis');
 184     $activityParams['status_id'] = CRM_Core_OptionGroup::getValue('activity_status', 'Completed', 'name');
 185     $activityParams['case_id'] = $caseId;
 186     $activityParams['is_auto'] = 0;
 187     $activityParams['subject'] = 'Client Added To Case';
 188
 189     $activity = CRM_Activity_BAO_Activity::create($activityParams);
 190
 191     $caseParams = array(
 192       'activity_id' => $activity->id,
 193       'case_id' => $caseId,
 194     );
 195
 196     CRM_Case_BAO_Case::processCaseActivity($caseParams);
 197     CRM_Utils_JSON::output(TRUE);
 198   }
 199
 200   /**
 201    * Delete relationships specific to case and relationship type
 202    */
 203   public static function deleteCaseRoles() {
 204     $caseId  = CRM_Utils_Type::escape($_POST['case_id'], 'Positive');
 205     $relType = CRM_Utils_Type::escape($_POST['rel_type'], 'Positive');
 206
 207     if (!$relType || !CRM_Case_BAO_Case::accessCase($caseId)) {
 208       CRM_Utils_System::permissionDenied();
 209     }
 210
 211     $sql = "DELETE FROM civicrm_relationship WHERE case_id={$caseId} AND relationship_type_id={$relType}";
 212     CRM_Core_DAO::executeQuery($sql);
 213
 214     CRM_Utils_System::civiExit();
 215   }
 216 }