* @param array $params
*
* @code
- * //REQUIRED:
+ * //REQUIRED for create:
* 'case_type_id' => int OR
* 'case_type' => str (provide one or the other)
* 'contact_id' => int // case client
* 'subject' => str
+ * //REQUIRED for update:
+ * 'id' => case Id
*
* //OPTIONAL
* 'medium_id' => int // see civicrm option values for possibilities
* api result array
*/
function civicrm_api3_case_create($params) {
+ _civicrm_api3_case_format_params($params);
- if (!empty($params['id'])) {
- return civicrm_api3_case_update($params);
+ if (empty($params['id'])) {
+ // Creating a new case, so make sure we have the necessary parameters
+ civicrm_api3_verify_mandatory($params, NULL, array(
+ 'contact_id',
+ 'subject',
+ array('case_type', 'case_type_id'),
+ )
+ );
}
+ else {
+ // Update an existing case
+ // FIXME: Some of this logic should move to the BAO object?
+ // FIXME: Should we check if case with ID actually exists?
+ if (!isset($params['case_id']) && isset($params['id'])) {
+ $params['case_id'] = $params['id'];
+ }
- civicrm_api3_verify_mandatory($params, NULL, array(
- 'contact_id',
- 'subject',
- array('case_type', 'case_type_id'))
- );
- _civicrm_api3_case_format_params($params);
+ if (array_key_exists('creator_id', $params)) {
+ throw new API_Exception('You cannot update creator id');
+ }
- // If format_params didn't find what it was looking for, return error
- if (empty($params['case_type_id'])) {
- throw new API_Exception('Invalid case_type. No such case type exists.');
- }
- if (empty($params['case_type'])) {
- throw new API_Exception('Invalid case_type_id. No such case type exists.');
- }
+ $mergedCaseId = $origContactIds = array();
- // Fixme: can we safely pass raw params to the BAO?
- $newParams = array(
- 'case_type_id' => $params['case_type_id'],
- 'creator_id' => $params['creator_id'],
- 'status_id' => $params['status_id'],
- 'start_date' => $params['start_date'],
- 'end_date' => CRM_Utils_Array::value('end_date', $params),
- 'subject' => $params['subject'],
- );
+ // get original contact id and creator id of case
+ if (!empty($params['contact_id'])) {
+ $origContactIds = CRM_Case_BAO_Case::retrieveContactIdsByCaseId($params['id']);
+ $origContactId = CRM_Utils_Array::first($origContactIds);
+ }
+
+ // FIXME: Refactor as separate method to get contactId
+ if (count($origContactIds) > 1) {
+ // check valid orig contact id
+ if (empty($params['orig_contact_id'])) {
+ throw new API_Exception('Case is linked with more than one contact id. Provide the required params orig_contact_id to be replaced');
+ }
+ if (!empty($params['orig_contact_id']) && !in_array($params['orig_contact_id'], $origContactIds)) {
+ throw new API_Exception('Invalid case contact id (orig_contact_id)');
+ }
+ $origContactId = $params['orig_contact_id'];
+ }
- $caseBAO = CRM_Case_BAO_Case::create($newParams);
+ // check for same contact id for edit Client
+ if (!empty($params['contact_id']) && !in_array($params['contact_id'], $origContactIds)) {
+ $mergedCaseId = CRM_Case_BAO_Case::mergeCases($params['contact_id'], $params['case_id'], $origContactId, NULL, TRUE);
+ }
+
+ // If we merged cases then update the merged case
+ if (!empty($mergedCaseId[0])) {
+ $params['id'] = $mergedCaseId[0];
+ }
+ }
+
+ // Create/update the case
+ $caseBAO = CRM_Case_BAO_Case::create($params);
if (!$caseBAO) {
throw new API_Exception('Case not created. Please check input params.');
}
- foreach ((array) $params['contact_id'] as $cid) {
- $contactParams = array('case_id' => $caseBAO->id, 'contact_id' => $cid);
- CRM_Case_BAO_CaseContact::create($contactParams);
+ if (isset($params['contact_id'])) {
+ foreach ((array) $params['contact_id'] as $cid) {
+ $contactParams = array('case_id' => $caseBAO->id, 'contact_id' => $cid);
+ CRM_Case_BAO_CaseContact::create($contactParams);
+ }
+ }
+
+ if (!isset($params['id'])) {
+ // As the API was not passed an id we have created a new case.
+ // Only run the xmlProcessor for new cases to get all configuration for the new case.
+ _civicrm_api3_case_create_xmlProcessor($params, $caseBAO);
+ }
+
+ // return case
+ $values = array();
+ _civicrm_api3_object_to_array($caseBAO, $values[$caseBAO->id]);
+
+ return civicrm_api3_create_success($values, $params, 'Case', 'create', $caseBAO);
+}
+
+/**
+ * When creating a new case, run the xmlProcessor to get all necessary params/configuration
+ * for the new case, as cases use an xml file to store their configuration.
+ * @param $params
+ * @param $caseBAO
+ */
+function _civicrm_api3_case_create_xmlProcessor($params, $caseBAO) {
+ // Format params for xmlProcessor
+ if (isset($caseBAO->id)) {
+ $params['id'] = $caseBAO->id;
}
// Initialize XML processor with $params
$xmlProcessor = new CRM_Case_XMLProcessor_Process();
$xmlProcessorParams = array(
- 'clientID' => $params['contact_id'],
- 'creatorID' => $params['creator_id'],
+ 'clientID' => CRM_Utils_Array::value('contact_id', $params),
+ 'creatorID' => CRM_Utils_Array::value('creator_id', $params),
'standardTimeline' => 1,
'activityTypeName' => 'Open Case',
- 'caseID' => $caseBAO->id,
- 'subject' => $params['subject'],
+ 'caseID' => CRM_Utils_Array::value('id', $params),
+ 'subject' => CRM_Utils_Array::value('subject', $params),
'location' => CRM_Utils_Array::value('location', $params),
- 'activity_date_time' => $params['start_date'],
+ 'activity_date_time' => CRM_Utils_Array::value('start_date', $params),
'duration' => CRM_Utils_Array::value('duration', $params),
'medium_id' => CRM_Utils_Array::value('medium_id', $params),
'details' => CRM_Utils_Array::value('details', $params),
// Do it! :-D
$xmlProcessor->run($params['case_type'], $xmlProcessorParams);
-
- // return case
- $values = array();
- _civicrm_api3_object_to_array($caseBAO, $values[$caseBAO->id]);
-
- return civicrm_api3_create_success($values, $params, 'Case', 'create', $caseBAO);
}
/**
* 'client_id' => finds all cases with a specific client
* 'activity_id' => returns the case containing a specific activity
* 'contact_id' => finds all cases associated with a contact (in any role, not just client)
+ * $params CRM_Utils_SQL_Select $sql
+ * Other apis wishing to wrap & extend this one can pass in a $sql object with extra clauses
*
* @throws API_Exception
* @return array
* (get mode, case_id provided): Array with case details, case roles, case activity ids, (search mode, case_id not provided): Array of cases found
*/
-function civicrm_api3_case_get($params) {
+function civicrm_api3_case_get($params, $sql = NULL) {
$options = _civicrm_api3_get_options_from_params($params);
- $sql = CRM_Utils_SQL_Select::fragment();
+ if (!is_a($sql, 'CRM_Utils_SQL_Select')) {
+ $sql = CRM_Utils_SQL_Select::fragment();
+ }
// Add clause to search by client
if (!empty($params['contact_id'])) {
$sql->where("a.id IN (SELECT case_id FROM civicrm_case_contact WHERE $clause)");
}
+ // Order by case contact (primary client)
+ // Ex: "contact_id", "contact_id.display_name", "contact_id.sort_name DESC".
+ if (!empty($options['sort']) && strpos($options['sort'], 'contact_id') !== FALSE) {
+ $sort = explode(', ', $options['sort']);
+ $contactSort = NULL;
+ foreach ($sort as $index => &$sortString) {
+ if (strpos($sortString, 'contact_id') === 0) {
+ $contactSort = $sortString;
+ $sortString = '(1)';
+ // Get sort field and direction
+ list($sortField, $dir) = array_pad(explode(' ', $contactSort), 2, 'ASC');
+ list(, $sortField) = array_pad(explode('.', $sortField), 2, 'id');
+ // Validate inputs
+ if (!array_key_exists($sortField, CRM_Contact_DAO_Contact::fieldKeys()) || ($dir != 'ASC' && $dir != 'DESC')) {
+ throw new API_Exception("Unknown field specified for sort. Cannot order by '$contactSort'");
+ }
+ $sql->orderBy("case_contact.$sortField $dir", NULL, $index);
+ }
+ }
+ // Remove contact sort params so the basic_get function doesn't see them
+ $params['options']['sort'] = implode(', ', $sort);
+ unset($params['option_sort'], $params['option.sort'], $params['sort']);
+ // Add necessary joins to the first case client
+ if ($contactSort) {
+ $sql->join('ccc', 'LEFT JOIN (SELECT * FROM civicrm_case_contact WHERE id IN (SELECT MIN(id) FROM civicrm_case_contact GROUP BY case_id)) AS ccc ON ccc.case_id = a.id');
+ $sql->join('case_contact', 'LEFT JOIN civicrm_contact AS case_contact ON ccc.contact_id = case_contact.id AND case_contact.is_deleted <> 1');
+ }
+ }
+
// Add clause to search by activity
if (!empty($params['activity_id'])) {
if (!CRM_Utils_Rule::positiveInteger($params['activity_id'])) {
);
}
+/**
+ * Add a timeline to a case.
+ *
+ * @param array $params
+ *
+ * @throws API_Exception
+ * @return array
+ */
+function civicrm_api3_case_addtimeline($params) {
+ $caseType = CRM_Case_BAO_Case::getCaseType($params['case_id'], 'name');
+ $xmlProcessor = new CRM_Case_XMLProcessor_Process();
+ $xmlProcessorParams = array(
+ 'clientID' => CRM_Case_BAO_Case::getCaseClients($params['case_id']),
+ 'creatorID' => $params['creator_id'],
+ 'standardTimeline' => 0,
+ 'activity_date_time' => $params['activity_date_time'],
+ 'caseID' => $params['case_id'],
+ 'caseType' => $caseType,
+ 'activitySetName' => $params['timeline'],
+ );
+ $xmlProcessor->run($caseType, $xmlProcessorParams);
+ return civicrm_api3_create_success();
+}
+
+/**
+ * Adjust Metadata for addtimeline action.
+ *
+ * @param array $params
+ * Array of parameters determined by getfields.
+ */
+function _civicrm_api3_case_addtimeline_spec(&$params) {
+ $params['case_id'] = array(
+ 'title' => 'Case ID',
+ 'description' => 'Id of case to update',
+ 'type' => CRM_Utils_Type::T_INT,
+ 'api.required' => 1,
+ );
+ $params['timeline'] = array(
+ 'title' => 'Timeline',
+ 'description' => 'Name of activity set',
+ 'type' => CRM_Utils_Type::T_STRING,
+ 'api.required' => 1,
+ );
+ $params['activity_date_time'] = array(
+ 'api.default' => 'now',
+ 'title' => 'Activity date time',
+ 'description' => 'Timeline start date',
+ 'type' => CRM_Utils_Type::T_DATE,
+ );
+ $params['creator_id'] = array(
+ 'api.default' => 'user_contact_id',
+ 'title' => 'Activity creator',
+ 'description' => 'Contact id of timeline creator',
+ 'type' => CRM_Utils_Type::T_INT,
+ );
+}
+
+/**
+ * Merge 2 cases.
+ *
+ * @param array $params
+ *
+ * @throws API_Exception
+ * @return array
+ */
+function civicrm_api3_case_merge($params) {
+ $clients1 = CRM_Case_BAO_Case::getCaseClients($params['case_id_1']);
+ $clients2 = CRM_Case_BAO_Case::getCaseClients($params['case_id_2']);
+ CRM_Case_BAO_Case::mergeCases($clients1[0], $params['case_id_1'], $clients2[0], $params['case_id_2']);
+ return civicrm_api3_create_success();
+}
+
+/**
+ * Adjust Metadata for merge action.
+ *
+ * @param array $params
+ * Array of parameters determined by getfields.
+ */
+function _civicrm_api3_case_merge_spec(&$params) {
+ $params['case_id_1'] = array(
+ 'title' => 'Case ID 1',
+ 'description' => 'Id of main case',
+ 'type' => CRM_Utils_Type::T_INT,
+ 'api.required' => 1,
+ );
+ $params['case_id_2'] = array(
+ 'title' => 'Case ID 2',
+ 'description' => 'Id of second case',
+ 'type' => CRM_Utils_Type::T_INT,
+ 'api.required' => 1,
+ );
+}
+
/**
* Declare deprecated api functions.
*
}
/**
- * Update a specified case.
+ * @deprecated Update a specified case. Use civicrm_api3_case_create() instead.
*
* @param array $params
* //REQUIRED:
// get original contact id and creator id of case
if (!empty($params['contact_id'])) {
$origContactIds = CRM_Case_BAO_Case::retrieveContactIdsByCaseId($params['id']);
- $origContactId = $origContactIds[1];
+ $origContactId = CRM_Utils_Array::first($origContactIds);
}
if (count($origContactIds) > 1) {
* @endcode
*
* @throws API_Exception
- * @return bool
- * true if success, else false
+ * @return mixed
*/
function civicrm_api3_case_delete($params) {
//check parameters
}
}
+/**
+ * Case.restore API specification
+ *
+ * @param array $spec description of fields supported by this API call
+ * @return void
+ */
+function _civicrm_api3_case_restore_spec(&$spec) {
+ $result = civicrm_api3('Case', 'getfields', array('api_action' => 'delete'));
+ $spec = array('id' => $result['values']['id']);
+}
+
+/**
+ * Restore a specified case from the trash.
+ *
+ * @param array $params
+ * @throws API_Exception
+ * @return mixed
+ */
+function civicrm_api3_case_restore($params) {
+ if (CRM_Case_BAO_Case::restoreCase($params['id'])) {
+ return civicrm_api3_create_success($params, $params, 'Case', 'restore');
+ }
+ else {
+ throw new API_Exception('Could not restore case.');
+ }
+}
+
/**
* Augment case results with extra data.
*
* @param array $params
*/
function _civicrm_api3_case_format_params(&$params) {
- // figure out case type id from case type and vice-versa
+ // Format/include custom params
+ $values = array();
+ _civicrm_api3_custom_format_params($params, $values, 'Case');
+ $params = array_merge($params, $values);
+
+ if (empty($params['case_type_id']) && empty($params['case_type'])) {
+ return;
+ }
+
+ // figure out case_type_id from case_type and vice-versa
$caseTypes = CRM_Case_PseudoConstant::caseType('name', FALSE);
if (empty($params['case_type_id'])) {
$params['case_type_id'] = array_search($params['case_type'], $caseTypes);
}
}
+
/**
* It actually works a lot better to use the CaseContact api instead of the Case api
* for entityRef fields so we can perform the necessary joins,