/**
* Method to import briefing expert data for case_id
*
* @param $caseId
*/
public function importBriefing($caseId)
{
$query = 'SELECT act.status_id, act.activity_date_time FROM civicrm_case_activity cact
JOIN civicrm_activity act ON cact.activity_id = act.id AND act.is_current_revision = %1 AND act.is_deleted = %2
WHERE act.activity_type_id = %3 AND cact.case_id = %4';
$params = array(1 => array(1, 'Integer'), 2 => array(0, 'Integer'), 3 => array($this->_briefingActivityTypeId, 'Integer'), 4 => array($caseId, 'Integer'));
$dao = CRM_Core_DAO::executeQuery($query, $params);
while ($dao->fetch()) {
if (CRM_Casereports_Activity::caseExists($caseId) == TRUE) {
$update = 'UPDATE civicrm_pum_case_reports SET briefing_status = %1, briefing_date = %2 WHERE case_id = %3';
$values = array(1 => array(CRM_Casereports_Activity::setBriefingStatusColumn($dao->status_id), 'String'), 2 => array(date('Ymd', strtotime($dao->activity_date_time)), 'String'), 3 => array($caseId, 'Integer'));
CRM_Core_DAO::executeQuery($update, $values);
} else {
$insert = 'INSERT INTO civicrm_pum_case_reports (case_id, briefing_status, briefing_date)
VALUES(%1, %2, %3)';
$values = array(1 => array($caseId, 'Integer'), 2 => array(CRM_Casereports_Activity::setBriefingStatusColumn($dao->status_id), 'String'), 3 => array(date('Ymd', strtotime($dao->activity_date_time)), 'String'));
CRM_Core_DAO::executeQuery($insert, $values);
}
}
}
