3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.5 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2014 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
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. |
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. |
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 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2014
36 * This class contains all case related functions that are called using AJAX (jQuery)
38 class CRM_Case_Page_AJAX
{
41 * Retrieve unclosed cases.
43 static function unclosedCases() {
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'),
49 $excludeCaseIds = array();
50 if (!empty($_GET['excludeCaseIds'])) {
51 $excludeCaseIds = explode(',', CRM_Utils_Type
::escape($_GET['excludeCaseIds'], 'String'));
53 $unclosedCases = CRM_Case_BAO_Case
::getUnclosedCases($params, $excludeCaseIds, TRUE, TRUE);
55 foreach ($unclosedCases as $caseId => $details) {
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'] . ')'),
64 CRM_Utils_JSON
::output($results);
67 function processCaseTags() {
69 $caseId = CRM_Utils_Type
::escape($_POST['case_id'], 'Positive');
70 $tags = CRM_Utils_Type
::escape($_POST['tag'], 'String');
71 $tagList = $_POST['taglist'];
73 if (!CRM_Case_BAO_Case
::accessCase($caseId)) {
74 CRM_Utils_System
::permissionDenied();
79 $tagIds = explode(',', $tags);
82 if (!empty($tagIds)) {
84 'entity_id' => $caseId,
85 'entity_table' => 'civicrm_case',
88 CRM_Core_BAO_EntityTag
::del($params);
90 foreach ($tagIds as $tagid) {
91 if (is_numeric($tagid)) {
92 $params['tag_id'] = $tagid;
93 CRM_Core_BAO_EntityTag
::add($params);
98 if (!empty($tagList)) {
99 CRM_Core_Form_Tag
::postProcess($tagList, $caseId, 'civicrm_case', CRM_Core_DAO
::$_nullObject);
102 $session = CRM_Core_Session
::singleton();
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';
113 $activity = CRM_Activity_BAO_Activity
::create($activityParams);
116 'activity_id' => $activity->id
,
117 'case_id' => $caseId,
120 CRM_Case_BAO_Case
::processCaseActivity($caseParams);
123 CRM_Utils_System
::civiExit();
126 function caseDetails() {
127 $caseId = CRM_Utils_Type
::escape($_GET['caseId'], 'Positive');
129 if (!CRM_Case_BAO_Case
::accessCase($caseId, FALSE)) {
130 CRM_Utils_System
::permissionDenied();
133 $sql = "SELECT civicrm_case.*, civicrm_case_type.title as case_type
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')));
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);
155 CRM_Core_Error
::fatal('Could not find valid Case.');
157 CRM_Utils_System
::civiExit();
160 function addClient() {
161 $caseId = CRM_Utils_Type
::escape($_POST['caseID'], 'Positive');
162 $contactId = CRM_Utils_Type
::escape($_POST['contactID'], 'Positive');
164 if (!$contactId ||
!CRM_Case_BAO_Case
::accessCase($caseId)) {
165 CRM_Utils_System
::permissionDenied();
169 'case_id' => $caseId,
170 'contact_id' => $contactId,
173 CRM_Case_BAO_Case
::addCaseToContact($params);
175 // add case relationships
176 CRM_Case_BAO_Case
::addCaseRelationships($caseId, $contactId);
178 $session = CRM_Core_Session
::singleton();
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';
189 $activity = CRM_Activity_BAO_Activity
::create($activityParams);
192 'activity_id' => $activity->id
,
193 'case_id' => $caseId,
196 CRM_Case_BAO_Case
::processCaseActivity($caseParams);
197 CRM_Utils_JSON
::output(TRUE);
201 * Delete relationships specific to case and relationship type
203 static function deleteCaseRoles() {
204 $caseId = CRM_Utils_Type
::escape($_POST['case_id'], 'Positive');
205 $relType = CRM_Utils_Type
::escape($_POST['rel_type'], 'Positive');
207 if (!$relType ||
!CRM_Case_BAO_Case
::accessCase($caseId)) {
208 CRM_Utils_System
::permissionDenied();
211 $sql = "DELETE FROM civicrm_relationship WHERE case_id={$caseId} AND relationship_type_id={$relType}";
212 CRM_Core_DAO
::executeQuery($sql);
214 CRM_Utils_System
::civiExit();