/** * Process the form submission. * * * @param CRM_Core_Form $form * @param array $params * @param CRM_Activity_BAO_Activity $activity */ public static function endPostProcess(&$form, &$params, $activity) { $groupingValues = CRM_Core_OptionGroup::values('case_status', FALSE, TRUE, FALSE, NULL, 'value'); // Set case end_date if we're closing the case. Clear end_date if we're (re)opening it. if (CRM_Utils_Array::value($params['case_status_id'], $groupingValues) == 'Closed' && !empty($params['activity_date_time'])) { $params['end_date'] = $params['activity_date_time']; // End case-specific relationships (roles) foreach ($params['target_contact_id'] as $cid) { $rels = CRM_Case_BAO_Case::getCaseRoles($cid, $params['case_id']); // FIXME: Is there an existing function to close a relationship? $query = 'UPDATE civicrm_relationship SET end_date=%2 WHERE id=%1'; foreach ($rels as $relId => $relData) { $relParams = array(1 => array($relId, 'Integer'), 2 => array($params['end_date'], 'Timestamp')); CRM_Core_DAO::executeQuery($query, $relParams); } } } elseif (CRM_Utils_Array::value($params['case_status_id'], $groupingValues) == 'Opened') { $params['end_date'] = "null"; // Reopen case-specific relationships (roles) foreach ($params['target_contact_id'] as $cid) { $rels = CRM_Case_BAO_Case::getCaseRoles($cid, $params['case_id']); // FIXME: Is there an existing function? $query = 'UPDATE civicrm_relationship SET end_date=NULL WHERE id=%1'; foreach ($rels as $relId => $relData) { $relParams = array(1 => array($relId, 'Integer')); CRM_Core_DAO::executeQuery($query, $relParams); } } } $params['status_id'] = CRM_Core_OptionGroup::getValue('activity_status', 'Completed', 'name'); $activity->status_id = $params['status_id']; $params['priority_id'] = CRM_Core_OptionGroup::getValue('priority', 'Normal', 'name'); $activity->priority_id = $params['priority_id']; foreach ($form->_oldCaseStatus as $statuskey => $statusval) { if ($activity->subject == 'null') { $activity->subject = ts('Case status changed from %1 to %2', array(1 => CRM_Utils_Array::value($statusval, $form->_caseStatus), 2 => CRM_Utils_Array::value($params['case_status_id'], $form->_caseStatus))); $activity->save(); } } // FIXME: does this do anything ? $params['statusMsg'] = ts('Case Status changed successfully.'); }