public static function registerResources($contactID, $absenceTypes = NULL, $activityTypes = NULL, $periods = NULL)
{
static $loaded = FALSE;
if ($loaded) {
return;
}
$loaded = TRUE;
CRM_Core_Resources::singleton()->addSettingsFactory(function () use($contactID, $absenceTypes, $activityTypes, $periods) {
if ($periods === NULL) {
$res = civicrm_api3('HRAbsencePeriod', 'get', array('options' => array('sort' => "start_date DESC")));
$periods = $res['values'];
}
if ($absenceTypes === NULL) {
$res = civicrm_api3('HRAbsenceType', 'get', array());
$absenceTypes = $res['values'];
}
if ($activityTypes === NULL) {
$activityTypes = CRM_HRAbsence_BAO_HRAbsenceType::getActivityTypes();
}
$legend = new CRM_HRAbsence_TypeLegend(9, $absenceTypes, $activityTypes);
$i = 1;
foreach ($periods as $key => $val) {
$sortPeriods[$i] = $val;
$i++;
}
return array('PseudoConstant' => array('locationType' => CRM_Core_PseudoConstant::get('CRM_Core_DAO_Address', 'location_type_id'), 'absenceStatus' => CRM_HRAbsence_BAO_HRAbsenceType::getActivityStatus()), 'Permissions' => array('viewWidget' => CRM_HRAbsence_Page_EmployeeAbsencePage::checkPermissions($contactID, 'viewWidget'), 'newAbsences' => CRM_HRAbsence_Page_EmployeeAbsencePage::checkPermissions($contactID, 'enableNewAbsence'), 'enableEntitlement' => CRM_HRAbsence_Page_EmployeeAbsencePage::checkPermissions($contactID, 'enableEntitlements'), 'getJobInfo' => CRM_HRAbsence_Page_EmployeeAbsencePage::checkPermissions($contactID, 'getJobInfo'), 'getOwnJobInfo' => CRM_HRAbsence_Page_EmployeeAbsencePage::checkPermissions($contactID, 'getOwnJobInfo')), 'FieldOptions' => CRM_HRAbsence_Page_EmployeeAbsencePage::getFieldOptions(), 'absenceApp' => array('contactId' => $contactID, 'activityTypes' => $activityTypes, 'absenceTypes' => $absenceTypes, 'legend' => $legend->getMap(), 'periods' => $periods, 'sortPeriods' => $sortPeriods, 'standardDay' => 8 * 60, 'apiTsFmt' => 'YYYY-MM-DD HH:mm:ss'));
})->addScriptFile('civicrm', 'packages/momentjs/moment.min.js', 100, 'html-header', FALSE)->addScriptFile('civicrm', 'packages/backbone/json2.js', 100, 'html-header', FALSE)->addScriptFile('civicrm', 'packages/backbone/backbone.js', 120, 'html-header')->addScriptFile('civicrm', 'packages/backbone/backbone.marionette.js', 125, 'html-header', FALSE)->addScriptFile('civicrm', 'packages/backbone/backbone.modelbinder.js', 125, 'html-header', FALSE)->addScriptFile('civicrm', 'js/crm.backbone.js', 130, 'html-header', FALSE)->addStyleFile('org.civicrm.hrabsence', 'css/hrabsence.css', 140, 'html-header')->addStyleFile('org.civicrm.hrabsence', 'css/jquery.multiselect.css', 140, 'html-header')->addScriptFile('org.civicrm.hrabsence', 'js/jquery.multiselect.js', 140, 'html-header');
self::addScriptFiles('org.civicrm.hrabsence', 'js/*.js', 200, 'html-header');
self::addScriptFiles('org.civicrm.hrabsence', 'js/*/*.js', 300, 'html-header');
self::addScriptFiles('org.civicrm.hrabsence', 'js/*/*/*.js', 400, 'html-header');
self::addTemplateFiles('org.civicrm.hrabsence', 'CRM/HRAbsence/Underscore/*.tpl', 'page-header');
// self::addTemplates('civicrm', 'CRM/Form/validate.tpl', 'page-header');
}
function __construct()
{
// There could be multiple contacts. We not clear on which contact id to display.
// Lets hide it for now.
$this->_exposeContactID = FALSE;
$this->activityTypes = CRM_HRAbsence_BAO_HRAbsenceType::getActivityTypes();
$this->activityStatus = CRM_HRAbsence_BAO_HRAbsenceType::getActivityStatus('name');
asort($this->activityTypes);
$this->_columns = array('civicrm_contact' => array('dao' => 'CRM_Contact_DAO_Contact', 'fields' => array('display_name' => array('name' => 'sort_name', 'title' => ts('Individual'), 'default' => TRUE, 'required' => TRUE)), 'filters' => array('sort_name' => array('name' => 'sort_name', 'title' => ts('Individual'), 'operator' => 'like', 'dbAlias' => 'cc.sort_name', 'type' => CRM_Report_Form::OP_STRING), 'current_user' => array('name' => 'current_user', 'title' => ts('Limit To Current User'), 'type' => CRM_Utils_Type::T_INT, 'operatorType' => CRM_Report_Form::OP_SELECT, 'options' => array('0' => ts('No'), '1' => ts('Yes'))))), 'civicrm_activity' => array('dao' => 'CRM_Activity_DAO_Activity', 'fields' => array('id' => array('no_display' => TRUE, 'title' => ts('Activity ID'), 'required' => TRUE), 'source_record_id' => array('no_display' => TRUE, 'required' => TRUE), 'activity_type_id' => array('title' => ts('Absence Type'), 'required' => TRUE, 'type' => CRM_Utils_Type::T_STRING)), 'filters' => array('absence_date' => array('title' => ts('Absence Date'), 'type' => CRM_Utils_Type::T_DATE, 'operatorType' => CRM_Report_Form::OP_DATE), 'activity_type_id' => array('title' => ts('Absence Type'), 'operatorType' => CRM_Report_Form::OP_MULTISELECT, 'options' => $this->activityTypes), 'status_id' => array('title' => ts('Status'), 'operatorType' => CRM_Report_Form::OP_MULTISELECT, 'options' => CRM_HRAbsence_BAO_HRAbsenceType::getActivityStatus()))), 'civicrm_activity_contact' => array('dao' => 'CRM_Activity_DAO_ActivityContact', 'fields' => array()));
parent::__construct();
}
/**
* Get duration of absences, in minutes.
*
* @param array $absenceTypeNames
* @param $periodId
*
* @return int
*/
private static function getAbsenceDuration($absenceTypeNames = array(), $periodId)
{
$absenceTypeIds = static::getActivityIdsForAbsenceTypeNames($absenceTypeNames, $periodId);
$activityStatuses = CRM_HRAbsence_BAO_HRAbsenceType::getActivityStatus('name');
$sql = "\n SELECT SUM(a1.duration) duration\n FROM civicrm_activity a\n\n INNER JOIN civicrm_activity_contact ac\n ON a.id = ac.activity_id\n\n INNER JOIN civicrm_contact c\n ON (ac.contact_id = c.id AND c.contact_type = 'Individual')\n\n INNER JOIN civicrm_hrjobcontract jc\n ON c.id = jc.contact_id AND jc.is_primary = 1\n\n INNER JOIN civicrm_hrjobcontract_revision jcr\n ON (jc.id = jcr.jobcontract_id AND jcr.effective_date <= NOW())\n\n INNER JOIN civicrm_hrjobcontract_details jcd\n ON (jcr.id = jcd.jobcontract_revision_id AND (jcd.period_end_date >= NOW() OR jcd.period_end_date IS NULL))\n\n INNER JOIN civicrm_activity a1\n ON (a.id = a1.source_record_id AND a1.activity_type_id = %1 AND a1.status_id = %2)\n\n WHERE\n a.id IN (" . implode(',', $absenceTypeIds) . ")\n AND a.status_id = %2\n ";
$params = array(1 => array(static::getAbsenceActivityTypeId(), 'Integer'), 2 => array(CRM_Utils_Array::key('Completed', $activityStatuses), 'Integer'));
$duration = 0;
$dao = CRM_Core_DAO::executeQuery($sql, $params);
if ($dao->fetch()) {
$duration = $dao->duration;
}
return $duration;
}
/**
* {@inheritDoc}
*/
public function toApiOutput($apiRequest, $result)
{
if (isset($apiRequest['params']['options']) && CRM_Utils_Array::value('absence-range', $apiRequest['params']['options'], FALSE)) {
if (!CRM_Utils_Array::value('is_error', $result, FALSE) && !empty($result['values'])) {
$absenceTypeId = array_search('Absence', CRM_Core_PseudoConstant::activityType());
if (!$absenceTypeId) {
throw new API_Exception("Failed to determine activity type ID of absences");
}
$ids = array_keys($result['values']);
$ids = array_filter($ids, 'is_numeric');
// paranoia
foreach ($ids as $id) {
$result['values'][$id]['absence_range'] = array('low' => NULL, 'high' => NULL, 'approved_duration' => 0, 'duration' => 0, 'count' => 0, 'items' => array());
}
$sql = "\n SELECT id, source_record_id, activity_date_time, status_id, duration as duration\n FROM civicrm_activity\n WHERE activity_type_id = %1 AND source_record_id in (" . implode(',', $ids) . ")\n ";
$params = array(1 => array($absenceTypeId, 'Integer'));
$dao = CRM_Core_DAO::executeQuery($sql, $params);
$activityStatus = CRM_HRAbsence_BAO_HRAbsenceType::getActivityStatus('name');
while ($dao->fetch()) {
$ar =& $result['values'][$dao->source_record_id]['absence_range'];
if ($ar['low'] === NULL || $ar['low'] > $dao->activity_date_time) {
$ar['low'] = $dao->activity_date_time;
}
if ($ar['high'] === NULL || $ar['high'] < $dao->activity_date_time) {
$ar['high'] = $dao->activity_date_time;
}
if ($dao->status_id == CRM_Utils_Array::key('Completed', $activityStatus)) {
$ar['approved_duration'] += $dao->duration;
}
$ar['duration'] += $dao->duration;
$ar['count']++;
$ar['items'][] = array('id' => $dao->id, 'activity_date_time' => $dao->activity_date_time, 'duration' => $dao->duration);
}
}
}
return $result;
}
/**
* This function is called after the user submits the form.
*
* @access public
*
* @return none
*/
public function postProcess()
{
global $user;
$isAdmin = in_array('civihr_admin', $user->roles) ? true : false;
$session = CRM_Core_Session::singleton();
$submitValues = $this->_submitValues;
if (!empty($submitValues['contacts_id'])) {
$this->_targetContactID = $submitValues['contacts_id'];
}
$absentDateDurations = array();
$activityStatus = CRM_HRAbsence_BAO_HRAbsenceType::getActivityStatus('name');
$activityStatusId['status_id'] = CRM_Utils_Array::key('Completed', $activityStatus);
if (!empty($submitValues['date_values'])) {
foreach (explode('|', $submitValues['date_values']) as $key => $dateString) {
if ($dateString) {
$values = explode('(', $dateString);
$date = CRM_Utils_Date::processDate($values[0]);
$valuesDate = explode(':', $dateString);
$absentDateDurations[$date]['duration'] = (int) $valuesDate[1];
if (isset($valuesDate[2]) && $valuesDate[2] == 1 && $this->_showhide == 1 && array_key_exists('_qf_AbsenceRequest_done_save', $submitValues) || isset($valuesDate[2]) && $valuesDate[2] == 0 && $this->_showhide == 0 && array_key_exists('_qf_AbsenceRequest_done_save', $submitValues)) {
$absentDateDurations[$date]['approval'] = CRM_Utils_Array::key('Scheduled', $activityStatus);
} elseif (isset($valuesDate[2]) && $valuesDate[2] == 0 && $this->_showhide == 1) {
$absentDateDurations[$date]['approval'] = CRM_Utils_Array::key('Rejected', $activityStatus);
} elseif (array_key_exists('_qf_AbsenceRequest_done_saveandapprove', $submitValues) || array_key_exists('_qf_AbsenceRequest_done_approve', $submitValues)) {
$absentDateDurations[$date]['approval'] = CRM_Utils_Array::key('Completed', $activityStatus);
}
}
}
}
// set email template values
$taDays = explode('|', $submitValues['tot_app_days']);
$totDays = $taDays[0];
if (!empty($taDays[1])) {
$appDays = $taDays[1];
}
$msgTempResult = civicrm_api3('MessageTemplate', 'get', array('msg_title' => "Absence Email"));
$targetContactResult = civicrm_api3('contact', 'get', array('id' => $this->_targetContactID));
$mailprm[$this->_targetContactID]['display_name'] = $targetContactResult['values'][$this->_targetContactID]['display_name'];
$mailprm[$this->_targetContactID]['email'] = $targetContactResult['values'][$this->_targetContactID]['email'];
$tplParams = array('messageTemplateID' => $msgTempResult['values'][$msgTempResult['id']]['id'], 'empName' => $mailprm[$this->_targetContactID]['display_name'], 'absenceType' => $this->_absenceType, 'absentDateDurations' => $absentDateDurations, 'startDate' => $submitValues['start_date'], 'endDate' => $submitValues['end_date'], 'empPosition' => $this->_empPosition, 'totDays' => $totDays, 'jobHoursTime' => $this->_jobHoursTime);
if (!empty($appDays)) {
$tplParams['appDays'] = $appDays;
}
$sendTemplateParams = array('messageTemplateID' => $tplParams['messageTemplateID'], 'contactId' => $this->_targetContactID, 'tplParams' => $tplParams);
if ($this->_action & CRM_Core_Action::ADD) {
$activityParam = array('sequential' => 1, 'source_contact_id' => $this->_loginUserID, 'target_contact_id' => $this->_targetContactID, 'assignee_contact_id' => $this->_managerContactID, 'activity_type_id' => $this->_activityTypeID);
if (array_key_exists('_qf_AbsenceRequest_done_saveandapprove', $submitValues) || $isAdmin) {
$activityParam['status_id'] = CRM_Utils_Array::key('Completed', $activityStatus);
} else {
//we want to keep the activity status in Scheduled for new absence if save button is clicked
$activityParam['status_id'] = CRM_Utils_Array::key('Scheduled', $activityStatus);
}
$result = civicrm_api3('Activity', 'create', $activityParam);
//save the custom data
if (!empty($submitValues['hidden_custom'])) {
$customFields = CRM_Utils_Array::crmArrayMerge(CRM_Core_BAO_CustomField::getFields('Activity', FALSE, FALSE, $this->_activityTypeID), CRM_Core_BAO_CustomField::getFields('Activity', FALSE, FALSE, NULL, NULL, TRUE));
$customValues = CRM_Core_BAO_CustomField::postProcess($submitValues, $customFields, $result['id'], 'Activity');
CRM_Core_BAO_CustomValueTable::store($customValues, 'civicrm_activity', $result['id']);
}
if (!empty($customValues)) {
$customGroup = array();
foreach ($customValues as $fieldID => $values) {
foreach ($values as $fieldValue) {
$customValue = array('data' => $fieldValue['value']);
$customFields[$fieldID]['id'] = $fieldID;
$formattedValue = CRM_Core_BAO_CustomGroup::formatCustomValues($customValue, $customFields[$fieldID], TRUE);
$customGroup[$customFields[$fieldID]['groupTitle']][$customFields[$fieldID]['label']] = str_replace(' ', '', $formattedValue);
}
}
$sendTemplateParams['tplParams']['customGroup'] = $customGroup;
}
$activityLeavesParam = array('sequential' => 1, 'source_record_id' => $result['id'], 'activity_type_id' => CRM_Core_OptionGroup::getValue('activity_type', 'Absence', 'name'));
foreach ($absentDateDurations as $date => $duration) {
$activityLeavesParam['activity_date_time'] = $date;
$activityLeavesParam['duration'] = $duration['duration'];
$activityLeavesParam['status_id'] = $duration['approval'];
civicrm_api3('Activity', 'create', $activityLeavesParam);
}
if (array_key_exists('_qf_AbsenceRequest_done_save', $submitValues)) {
$sendTemplateParams['from'] = $mailprm[$this->_targetContactID]['email'];
CRM_Core_Session::setStatus(ts('Absence(s) have been applied.'), ts('Saved'), 'success');
} elseif (array_key_exists('_qf_AbsenceRequest_done_saveandapprove', $submitValues) || $isAdmin) {
if (!empty($this->_managerContactID)) {
$emailID = civicrm_api3('contact', 'get', array('id' => $this->_loginUserID));
$sendTemplateParams['from'] = $emailID['values'][$emailID['id']]['email'];
}
$sendTemplateParams['tplParams']['approval'] = TRUE;
CRM_Core_Session::setStatus(ts('Absence(s) have been applied and approved.'), ts('Saved'), 'success');
}
$managerContactResult = array();
if (!empty($this->_managerContactID)) {
foreach ($this->_managerContactID as $key => $val) {
$managerContactResult = civicrm_api3('contact', 'get', array('id' => $val));
if (!empty($val) && !empty($managerContactResult['values'])) {
$mailprm[$val]['display_name'] = $managerContactResult['values'][$val]['display_name'];
$mailprm[$val]['email'] = $managerContactResult['values'][$val]['email'];
}
}
}
self::sendAbsenceMail($mailprm, $sendTemplateParams);
$session->pushUserContext(CRM_Utils_System::url('civicrm/absences', "reset=1&cid={$this->_targetContactID}#hrabsence/list"));
} elseif ($this->_mode == 'edit') {
if (array_key_exists('_qf_AbsenceRequest_done_cancelabsence', $submitValues)) {
$statusId = CRM_Utils_Array::key('Cancelled', $activityStatus);
$activityParam = array('sequential' => 1, 'id' => $this->_activityId, 'activity_type_id' => $this->_activityTypeID, 'status_id' => $statusId);
$result = civicrm_api3('Activity', 'create', $activityParam);
$subact = civicrm_api3('Activity', 'get', array('return' => "id", 'source_record_id' => $result['id']));
foreach ($subact['values'] as $key => $val) {
civicrm_api3('Activity', 'create', array('id' => $val['id'], 'status_id' => $statusId));
}
$sendTemplateParams['from'] = $mailprm[$this->_targetContactID]['email'];
$sendTemplateParams['tplParams']['cancel'] = $sendMail = TRUE;
CRM_Core_Session::setStatus(ts('Absence(s) have been Cancelled.'), ts('Cancelled'), 'success');
$session->pushUserContext(CRM_Utils_System::url('civicrm/absence/set', "reset=1&action=view&aid={$result['id']}"));
} elseif (array_key_exists('_qf_AbsenceRequest_done_approve', $submitValues)) {
$statusId = CRM_Utils_Array::key('Completed', $activityStatus);
$activityParam = array('sequential' => 1, 'id' => $this->_activityId, 'activity_type_id' => $this->_activityTypeID, 'status_id' => $statusId);
$result = civicrm_api3('Activity', 'get', array('source_record_id' => $submitValues['source_record_id'], 'option.limit' => 365));
foreach ($result['values'] as $row_result) {
civicrm_api3('Activity', 'delete', array('id' => $row_result['id']));
}
foreach ($absentDateDurations as $date => $duration) {
$resultAct = civicrm_api3('Activity', 'create', array('activity_type_id' => CRM_Core_OptionGroup::getValue('activity_type', 'Absence', 'name'), 'source_record_id' => $submitValues['source_record_id'], 'activity_date_time' => $date, 'duration' => $duration['duration'], 'status_id' => $duration['approval']));
}
$result = civicrm_api3('Activity', 'create', $activityParam);
if (!empty($this->_managerContactID)) {
$emailID = civicrm_api3('contact', 'get', array('id' => $this->_loginUserID));
$sendTemplateParams['from'] = $emailID['values'][$emailID['id']]['email'];
}
$sendTemplateParams['tplParams']['approval'] = $sendMail = TRUE;
CRM_Core_Session::setStatus(ts('Absence(s) have been Approved.'), ts('Approved'), 'success');
$session->pushUserContext(CRM_Utils_System::url('civicrm/absence/set', "reset=1&action=view&aid={$result['id']}"));
} elseif (array_key_exists('_qf_AbsenceRequest_done_reject', $submitValues)) {
$statusId = CRM_Utils_Array::key('Rejected', $activityStatus);
$activityParam = array('id' => $this->_activityId, 'activity_type_id' => $this->_activityTypeID, 'status_id' => $statusId);
$result = civicrm_api3('Activity', 'create', $activityParam);
$subact = civicrm_api3('Activity', 'get', array('return' => "id", 'source_record_id' => $result['id']));
foreach ($subact['values'] as $key => $val) {
civicrm_api3('Activity', 'create', array('id' => $val['id'], 'status_id' => $statusId));
}
if (!empty($this->_managerContactID)) {
$emailID = civicrm_api3('contact', 'get', array('id' => $this->_loginUserID));
$sendTemplateParams['from'] = $emailID['values'][$emailID['id']]['email'];
}
$sendTemplateParams['tplParams']['reject'] = $sendMail = TRUE;
CRM_Core_Session::setStatus(ts('Absence(s) have been Rejected.'), ts('Rejected'), 'success');
$session->pushUserContext(CRM_Utils_System::url('civicrm/absence/set', "reset=1&action=view&aid={$result['id']}"));
} elseif (array_key_exists('_qf_AbsenceRequest_done_cancel', $submitValues)) {
$session->pushUserContext(CRM_Utils_System::url('civicrm/absences', "reset=1&cid={$this->_targetContactID}#hrabsence/list"));
} else {
$result = civicrm_api3('Activity', 'get', array('source_record_id' => $submitValues['source_record_id'], 'option.limit' => 365));
foreach ($result['values'] as $row_result) {
civicrm_api3('Activity', 'delete', array('id' => $row_result['id']));
}
foreach ($absentDateDurations as $date => $duration) {
$result = civicrm_api3('Activity', 'create', array('activity_type_id' => CRM_Core_OptionGroup::getValue('activity_type', 'Absence', 'name'), 'source_record_id' => $submitValues['source_record_id'], 'activity_date_time' => $date, 'duration' => $duration['duration'], 'status_id' => $duration['approval']));
}
$buttonName = $this->controller->getButtonName();
if ($buttonName == "_qf_AbsenceRequest_done_save") {
$this->_aid = $submitValues['source_record_id'];
$sendTemplateParams['from'] = $mailprm[$this->_targetContactID]['email'];
$sendTemplateParams['tplParams']['save'] = $sendMail = TRUE;
$session->pushUserContext(CRM_Utils_System::url('civicrm/absences', "reset=1&cid={$this->_targetContactID}#hrabsence/list"));
}
}
if (!empty($submitValues['hidden_custom'])) {
$customFields = CRM_Utils_Array::crmArrayMerge(CRM_Core_BAO_CustomField::getFields('Activity', FALSE, FALSE, $this->_activityTypeID), CRM_Core_BAO_CustomField::getFields('Activity', FALSE, FALSE, NULL, NULL, TRUE));
$customValues = CRM_Core_BAO_CustomField::postProcess($submitValues, $customFields, $result['id'], 'Activity');
CRM_Core_BAO_CustomValueTable::store($customValues, 'civicrm_activity', $result['id']);
}
if (!empty($customValues)) {
$customGroup = array();
foreach ($customValues as $fieldID => $values) {
foreach ($values as $fieldValue) {
$customValue = array('data' => $fieldValue['value']);
$customFields[$fieldID]['id'] = $fieldID;
$formattedValue = CRM_Core_BAO_CustomGroup::formatCustomValues($customValue, $customFields[$fieldID], TRUE);
$customGroup[$customFields[$fieldID]['groupTitle']][$customFields[$fieldID]['label']] = str_replace(' ', '', $formattedValue);
}
}
$sendTemplateParams['tplParams']['customGroup'] = $customGroup;
}
if ($sendMail) {
//send mail to multiple manager
$managerContactResult = array();
if (!empty($this->_managerContactID)) {
foreach ($this->_managerContactID as $key => $val) {
$managerContactResult = civicrm_api3('contact', 'get', array('id' => $val));
if (!empty($val) && !empty($managerContactResult['values'])) {
$mailprm[$val]['display_name'] = $managerContactResult['values'][$val]['display_name'];
$mailprm[$val]['email'] = $managerContactResult['values'][$val]['email'];
}
}
}
self::sendAbsenceMail($mailprm, $sendTemplateParams);
}
} else {
if (CRM_Utils_Request::retrieve('aid', 'Positive', $this)) {
$activityIDs = CRM_Utils_Request::retrieve('aid', 'Positive', $this);
}
if (array_key_exists('_qf_AbsenceRequest_done_cancelabsence', $submitValues)) {
$statusId = CRM_Utils_Array::key('Cancelled', $activityStatus);
$statusMsg = ts('Absence(s) have been Cancelled');
} elseif (array_key_exists('_qf_AbsenceRequest_done_cancel', $submitValues)) {
$session->pushUserContext(CRM_Utils_System::url('civicrm/absences', "reset=1&cid={$this->_targetContactID}#hrabsence/list"));
}
civicrm_api3('Activity', 'create', array('id' => $this->_activityId, 'activity_type_id' => $this->_activityTypeID, 'status_id' => $statusId));
CRM_Core_Session::setStatus($statusMsg, '', 'success');
$session->pushUserContext(CRM_Utils_System::url('civicrm/absence/set', "reset=1&action=view&aid={$activityIDs}"));
}
}
function alterDisplay(&$rows)
{
// custom code to alter rows
$entryFound = $viewLinks = FALSE;
$seperator = CRM_Core_DAO::VALUE_SEPARATOR;
$context = CRM_Utils_Request::retrieve('context', 'String', $this, FALSE, 'report');
if (CRM_Core_Permission::check('access CiviCRM')) {
$viewLinks = TRUE;
$onHover = ts('View Contact Summary for this Contact');
$onHoverAct = ts('View Absence Record');
}
if (!isset($this->_params['absence_date_from']) && !isset($this->_params['absence_date_to'])) {
$this->_params['absence_date_from'] = date('m/d/Y');
$this->_params['absence_date_to'] = date("m/d/Y", strtotime("+2 months"));
}
if (!empty($rows)) {
$activityTypeID = CRM_Core_OptionGroup::getValue('activity_type', 'Absence', 'name');
list($durationFromDate, $durationToDate) = $this->getFromTo(CRM_Utils_Array::value("absence_date_relative", $this->_params), CRM_Utils_Array::value("absence_date_from", $this->_params), CRM_Utils_Array::value("absence_date_to", $this->_params));
$activityStatus = CRM_HRAbsence_BAO_HRAbsenceType::getActivityStatus('name');
$activityStatusId = CRM_Utils_Array::key('Rejected', $activityStatus);
$completedActivityId = CRM_Utils_Array::key('Completed', $activityStatus);
$result = civicrm_api3('OptionValue', 'get', array('label' => "absence"));
$activityId = $result['values'][$result['id']]['value'];
$clause = NULL;
if ($status = CRM_Utils_Array::value("status_id_value", $this->_params)) {
$clause = " AND status_id IN (" . implode(',', $status) . ")";
}
$sql = "SELECT SUM(duration) / ( 8 *60 ) as qty,\n source_record_id ,\n Min(activity_date_time) AS start_date,\n Max(activity_date_time) AS end_date\n FROM civicrm_activity\n WHERE source_record_id IN (select id from civicrm_activity where source_record_id IS NULL AND status_id NOT IN ({$completedActivityId}) {$clause}) AND activity_type_id = {$activityId}\n GROUP BY source_record_id\n\n UNION\n\n SELECT SUM(CASE WHEN (activity_type_id = {$activityId} AND status_id NOT IN ({$activityStatusId})) THEN duration else NULL end) / ( 8 *60 ) as qty,\n source_record_id ,\n Min(activity_date_time) AS start_date,\n Max(activity_date_time) AS end_date\n FROM civicrm_activity\n WHERE source_record_id IN (select id from civicrm_activity where source_record_id IS NULL AND status_id IN ({$completedActivityId}) {$clause}) AND activity_type_id = {$activityId}\n GROUP BY source_record_id";
if ($durationFromDate && $durationToDate) {
$sql .= "\n HAVING ((to_days({$durationFromDate}) <= to_days(Min(activity_date_time))) AND\n (to_days(Max(activity_date_time)) <= to_days({$durationToDate})))\n ";
}
$data = array();
$dao = CRM_Core_DAO::executeQuery($sql);
while ($dao->fetch()) {
$data[$dao->source_record_id]['start_date'] = $dao->start_date;
$data[$dao->source_record_id]['end_date'] = $dao->end_date;
$data[$dao->source_record_id]['qty'] = round($dao->qty, 1);
}
}
foreach ($rows as $rowNum => $row) {
if (!array_key_exists($rows[$rowNum]['civicrm_activity_id'], $data)) {
unset($rows[$rowNum]);
continue;
}
if (array_key_exists($row['civicrm_activity_id'], $data)) {
$rows[$rowNum]['start_date'] = $data[$row['civicrm_activity_id']]['start_date'];
$rows[$rowNum]['end_date'] = $data[$row['civicrm_activity_id']]['end_date'];
$rows[$rowNum]['qty'] = $data[$row['civicrm_activity_id']]['qty'];
}
if (array_key_exists('civicrm_contact_contact_source', $row)) {
if ($value = $row['civicrm_contact_contact_source_id']) {
if ($viewLinks) {
$url = CRM_Utils_System::url("civicrm/contact/view", 'reset=1&cid=' . $value, $this->_absoluteUrl);
$rows[$rowNum]['civicrm_contact_contact_source_link'] = $url;
$rows[$rowNum]['civicrm_contact_contact_source_hover'] = $onHover;
}
$entryFound = TRUE;
}
}
if (array_key_exists('civicrm_contact_contact_assignee', $row)) {
$assigneeNames = explode(';', $row['civicrm_contact_contact_assignee']);
if ($value = $row['civicrm_contact_contact_assignee_id']) {
$assigneeContactIds = explode(';', $value);
$link = array();
if ($viewLinks) {
foreach ($assigneeContactIds as $id => $value) {
if (isset($value) && isset($assigneeNames[$id])) {
$url = CRM_Utils_System::url("civicrm/contact/view", 'reset=1&cid=' . $value, $this->_absoluteUrl);
$link[] = "<a title='" . $onHover . "' href='" . $url . "'>{$assigneeNames[$id]}</a>";
}
}
$rows[$rowNum]['civicrm_contact_contact_assignee'] = implode('; ', $link);
}
$entryFound = TRUE;
}
}
if (array_key_exists('civicrm_contact_contact_target', $row)) {
$targetNames = explode(';', $row['civicrm_contact_contact_target']);
if ($value = $row['civicrm_contact_contact_target_id']) {
$targetContactIds = explode(';', $value);
$link = array();
if ($viewLinks) {
foreach ($targetContactIds as $id => $value) {
if (isset($value) && isset($targetNames[$id])) {
$url = CRM_Utils_System::url("civicrm/contact/view", 'reset=1&cid=' . $value, $this->_absoluteUrl);
$link[] = "<a title='" . $onHover . "' href='" . $url . "'>{$targetNames[$id]}</a>";
}
}
$rows[$rowNum]['civicrm_contact_contact_target'] = implode('; ', $link);
}
$entryFound = TRUE;
}
}
if (array_key_exists('civicrm_activity_activity_type_id', $row)) {
if ($value = $row['civicrm_activity_activity_type_id']) {
$rows[$rowNum]['civicrm_activity_activity_type_id'] = $this->activityTypes[$value];
if ($viewLinks) {
// Check for target contact id(s) and use the first contact id in that list for view activity link if found,
// else use source contact id
if (!empty($rows[$rowNum]['civicrm_contact_contact_target_id'])) {
$targets = explode(';', $rows[$rowNum]['civicrm_contact_contact_target_id']);
$cid = $targets[0];
} else {
$cid = $rows[$rowNum]['civicrm_contact_contact_source_id'];
}
$url = CRM_Utils_System::url('civicrm/absence/set', 'reset=1&action=view&aid=' . $rows[$rowNum]['civicrm_activity_id'], $this->_absoluteUrl);
$rows[$rowNum]['civicrm_activity_activity_type_id_link'] = $url;
$rows[$rowNum]['civicrm_activity_activity_type_id_hover'] = $onHoverAct;
}
$entryFound = TRUE;
}
}
if (array_key_exists('civicrm_activity_status_id', $row)) {
if ($value = $row['civicrm_activity_status_id']) {
$rows[$rowNum]['civicrm_activity_status_id'] = $this->activityStatus[$value];
$entryFound = TRUE;
}
}
if (array_key_exists('civicrm_activity_activity_date_time', $row) && array_key_exists('civicrm_activity_status_id', $row)) {
if (CRM_Utils_Date::overdue($rows[$rowNum]['civicrm_activity_activity_date_time']) && $this->activityStatus[$row['civicrm_activity_status_id']] != 'Approved') {
$rows[$rowNum]['class'] = "status-overdue";
$entryFound = TRUE;
}
}
if (!$entryFound) {
break;
}
}
}
<?php
// This file declares a managed database record of type "ReportTemplate".
// The record will be automatically inserted, updated, or deleted from the
// database as appropriate. For more details, see "hook_civicrm_managed" at:
// http://wiki.civicrm.org/confluence/display/CRMDOC/Hook+Reference
$isEnabled = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_Extension', 'org.civicrm.hrabsence', 'is_active', 'full_name');
if ($isEnabled) {
$activityStatus = CRM_HRAbsence_BAO_HRAbsenceType::getActivityStatus();
$approvedStatus = array_search('Approved', $activityStatus);
} else {
$activityStatus = CRM_Core_PseudoConstant::activityStatus();
$approvedStatus = array_search('Completed', $activityStatus);
}
return array(array('name' => 'CiviHR Absence Report Template', 'entity' => 'ReportTemplate', 'params' => array('version' => 3, 'label' => 'CiviHR Absence Report', 'description' => 'HR Report showing absences at individual level. ', 'class_name' => 'CRM_HRReport_Form_Activity_HRAbsence', 'report_url' => 'civihr/absence', 'grouping' => 'Absence', 'component' => '')), array('name' => 'CiviHR Absence Report', 'entity' => 'ReportInstance', 'params' => array('version' => 3, 'title' => 'CiviHR Absence Report', 'description' => 'HR Report showing absences at individual level. ', 'report_id' => 'civihr/absence', 'form_values' => serialize(array('addToDashboard' => 1, 'fields' => array('id' => 1, 'contact_target' => 1, 'activity_type_id' => 1, 'duration' => 1, 'absence_date' => 1, 'status_id' => 1, 'this.month' => 1), 'status_id_op' => 'in', 'status_id_value' => array($approvedStatus))))));
public function upgrade_1401()
{
$this->ctx->log->info('Planning update 1401');
// PEAR Log interface
$params = array('title' => 'CiviHR Current Employees Report', 'description' => 'HR Report showing drilled down current employee details . ', 'report_id' => 'civihr/detail', 'form_values' => serialize(array('fields' => array('id' => 1, 'sort_name' => 1, 'email' => 1, 'manager' => 1, 'hrjob_title' => 1))));
$result = civicrm_api3('ReportInstance', 'create', $params);
CRM_Core_DAO::executeQuery("INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('org.civicrm.hrreport', 'CiviHR Current Employees Report', 'ReportInstance', {$result['id']})");
//Set approved filter ON for Absence report
$isEnabled = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_Extension', 'org.civicrm.hrabsence', 'is_active', 'full_name');
if ($isEnabled) {
$activityStatus = CRM_HRAbsence_BAO_HRAbsenceType::getActivityStatus();
$update_formValues = serialize(array('addToDashboard' => 1, 'fields' => array('id' => 1, 'contact_target' => 1, 'activity_type_id' => 1, 'duration' => 1, 'absence_date' => 1, 'status_id' => 1, 'this.month' => 1), 'status_id_op' => 'in', 'status_id_value' => array(array_search('Approved', $activityStatus))));
CRM_Core_DAO::executeQuery("UPDATE civicrm_report_instance SET form_values = '{$update_formValues}' WHERE id = (SELECT entity_id from civicrm_managed where name = 'CiviHR Absence Report')");
}
return TRUE;
}
