/**
* singleton function used to manage this object
*
* @return CRM_Hrjobcontract_ExportImportValuesConverter
* @static
*/
static function &singleton()
{
if (self::$_singleton === NULL) {
self::$_singleton = new self();
}
return self::$_singleton;
}
function alterDisplay(&$rows)
{
// custom code to alter rows
$entryFound = FALSE;
$entities = array('HRJobContract', 'HRJobDetails', 'HRJobHour', 'HRJobHealth', 'HRJobLeave', 'HRJobPay', 'HRJobPension', 'HRJobRole');
$ei = CRM_Hrjobcontract_ExportImportValuesConverter::singleton();
$changeReasonOptions = array();
CRM_Core_OptionGroup::getAssoc('hrjc_revision_change_reason', $changeReasonOptions);
foreach ($rows as $rowNum => $row) {
// make count columns point to detail report
// convert sort name to links
if (!empty($row['civicrm_contact_sort_name']) && !empty($row['civicrm_hrjobcontract_contact_id'])) {
$url = CRM_Report_Utils_Report::getNextUrl('contact/detail', 'reset=1&force=1&id_op=eq&id_value=' . $row['civicrm_hrjobcontract_contact_id'], $this->_absoluteUrl, $this->_id, $this->_drilldownReport);
$rows[$rowNum]['civicrm_contact_sort_name_link'] = $url;
$rows[$rowNum]['civicrm_contact_sort_name_hover'] = ts("View Constituent Detail Report for this contact.");
$entryFound = TRUE;
}
// Convert revisionable HRJobContract Entities values for export
foreach ($entities as $entity) {
$tableName = _civicrm_get_table_name($entity);
$fields = $this->_columns['civicrm_hrjobcontract_' . $tableName]['fields'];
foreach ($fields as $key => $value) {
$fieldName = substr($key, strlen($tableName) + 1);
$rowKey = 'civicrm_hrjobcontract_' . $tableName . '_' . $tableName . '_' . $fieldName;
if (isset($row[$rowKey])) {
$rows[$rowNum][$rowKey] = $ei->export($tableName, $fieldName, $row[$rowKey]);
}
}
}
// Convert non-revisionable HRJobContract Entities values for export
if (!empty($row['civicrm_hrjobcontract_revision_change_reason'])) {
$rows[$rowNum]['civicrm_hrjobcontract_revision_change_reason'] = $changeReasonOptions['label'][$rows[$rowNum]['civicrm_hrjobcontract_revision_change_reason']];
$entryFound = TRUE;
}
}
}
/**
* handle the values in import mode
*
* @param int $onDuplicate the code for what action to take on duplicates
* @param array $values the array of values belonging to this line
*
* @return boolean the result of this processing
* @access public
*/
function import($onDuplicate, &$values)
{
$entityNames = array('details', 'hour', 'health', 'leave', 'pay', 'pension', 'role');
$ei = CRM_Hrjobcontract_ExportImportValuesConverter::singleton();
$response = $this->summary($values);
$this->formatDateParams();
$this->_params['skipRecentView'] = TRUE;
$this->_params['check_permissions'] = TRUE;
$params = $this->getActiveFieldParams();
$formatValues = array();
foreach ($params as $key => $field) {
if ($field == NULL || $field === '') {
continue;
}
$formatValues[$key] = $field;
}
$importedJobContractId = null;
if (!empty($params['jobcontract_id'])) {
$importedJobContractId = (int) $params['jobcontract_id'];
}
if (!$importedJobContractId) {
$importedJobContractId = $this->_jobcontractIdIncremental++;
}
if (empty($params['contact_id']) && !empty($params['email'])) {
$checkEmail = new CRM_Core_BAO_Email();
$checkEmail->email = $params['email'];
$checkEmail->find(TRUE);
if (!empty($checkEmail->contact_id)) {
$params['contact_id'] = $checkEmail->contact_id;
}
}
if (!empty($formatValues['external_identifier'])) {
$checkCid = new CRM_Contact_DAO_Contact();
$checkCid->external_identifier = $formatValues['external_identifier'];
$checkCid->find(TRUE);
if (!empty($params['contact_id']) && $params['contact_id'] != $checkCid->id) {
array_unshift($values, 'Mismatch of External identifier :' . $formatValues['external_identifier'] . ' and Contact Id:' . $params['contact_id']);
return CRM_Import_Parser::ERROR;
}
if (!empty($checkCid->id)) {
$params['contact_id'] = $checkCid->id;
}
}
if (empty($params['contact_id'])) {
$error = 'Missing "contact_id" / "email" / "external_identifier" value.';
array_unshift($values, $error);
return CRM_Import_Parser::ERROR;
}
$revisionParams = $this->getEntityParams('HRJobContractRevision');
$revisionData = array();
foreach ($entityNames as $value) {
if (empty($revisionParams[$value . '_revision_id'])) {
$revisionParams[$value . '_revision_id'] = $this->_revisionIdIncremental;
}
$revisionData[$value] = $revisionParams[$value . '_revision_id'];
}
$this->_revisionIdIncremental++;
if (empty($revisionData)) {
$error = 'Missing Revision data.';
array_unshift($values, $error);
return CRM_Import_Parser::ERROR;
}
$revisionId = max($revisionData);
if (empty($this->_jobContractIds[$importedJobContractId])) {
try {
$jobContractCreateResponse = civicrm_api3('HRJobContract', 'create', array('contact_id' => $params['contact_id']));
} catch (CiviCRM_API3_Exception $e) {
$error = $e->getMessage();
array_unshift($values, $error);
return CRM_Import_Parser::ERROR;
}
$this->_jobContractIds[$importedJobContractId] = (int) $jobContractCreateResponse['id'];
$this->_previousRevision = array();
foreach ($entityNames as $value) {
$this->_previousRevision['imported'][$value] = null;
$this->_previousRevision['local'][$value] = null;
}
$this->_previousRevision['imported']['id'] = null;
$this->_previousRevision['local']['id'] = null;
$this->_revisionIds = array();
$this->_revisionEntityMap = array();
}
$localJobContractId = $this->_jobContractIds[$importedJobContractId];
$newRevisionInstance = null;
if ($this->_previousRevision['imported']['id'] !== $revisionId) {
// create new Revision:
$newRevisionParams = $revisionParams;
unset($newRevisionParams['id']);
foreach ($entityNames as $value) {
unset($newRevisionParams[$value . '_revision_id']);
}
$newRevisionParams['jobcontract_id'] = $localJobContractId;
$newRevisionParams = $this->validateFields('HRJobContractRevision', $newRevisionParams);
$newRevisionInstance = CRM_Hrjobcontract_BAO_HRJobContractRevision::create($newRevisionParams);
if (!empty($this->_previousRevision['imported']['id'])) {
foreach ($entityNames as $value) {
$field = $value . '_revision_id';
$newRevisionInstance->{$field} = $this->_previousRevision['local'][$value];
}
$newRevisionInstance->save();
}
}
try {
foreach ($this->_entity as $entity) {
if (in_array($entity, array('HRJobContract', 'HRJobContractRevision'))) {
continue;
}
$entityClass = 'CRM_Hrjobcontract_BAO_' . $entity;
$tableName = _civicrm_get_table_name($entity);
if (empty($revisionParams[$tableName . '_revision_id'])) {
continue;
}
$params = $this->getEntityParams($entity);
$params['jobcontract_id'] = $localJobContractId;
foreach ($params as $key => $value) {
$params[$key] = $ei->import($tableName, $key, $value);
}
$params = $this->validateFields($entity, $params);
$params['import'] = 1;
if ($revisionParams[$tableName . '_revision_id'] === $revisionId) {
if ($tableName === 'leave' || $this->_previousRevision['imported'][$tableName] !== $revisionId) {
if (!empty($newRevisionInstance)) {
$params['jobcontract_revision_id'] = $newRevisionInstance->id;
} else {
$params['jobcontract_revision_id'] = $this->_previousRevision['local'][$tableName];
}
if ($tableName === 'leave') {
foreach ($params['leave_amount'] as $leaveTypeId => $leaveAmount) {
$params['leave_type'] = $leaveTypeId;
$params['leave_amount'] = $leaveAmount;
$entityInstance = $entityClass::create($params);
}
} else {
$entityInstance = $entityClass::create($params);
}
$this->_previousRevision['local'][$tableName] = $entityInstance->jobcontract_revision_id;
}
}
$this->_previousRevision['imported'][$tableName] = $revisionParams[$tableName . '_revision_id'];
}
} catch (CiviCRM_API3_Exception $e) {
$error = $e->getMessage();
array_unshift($values, $error);
return CRM_Import_Parser::ERROR;
}
if (!empty($newRevisionInstance)) {
foreach ($entityNames as $value) {
$field = $value . '_revision_id';
$newRevisionInstance->{$field} = $this->_previousRevision['local'][$value];
}
$newRevisionInstance->save();
}
$this->_previousRevision['imported']['id'] = $revisionId;
}