protected function doExport($objEntity = null, array $arrFields = array())
{
switch ($this->type) {
case Exporter::TYPE_ITEM:
break;
case Exporter::TYPE_LIST:
$objDbResult = $this->getEntities();
$arrDca = $GLOBALS['TL_DCA'][$this->linkedTable];
if (!$objDbResult->numRows > 0) {
return;
}
$intCol = 0;
$intRow = 1;
// header
if ($this->objConfig->addHeaderToExportTable) {
foreach ($this->arrHeaderFields as $varValue) {
$this->objPhpExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($intCol, $intRow, $varValue);
$this->processHeaderRow($intCol);
$intCol++;
}
$intRow++;
}
// body
while ($objDbResult->next()) {
$arrRow = $objDbResult->row();
$intCol = 0;
foreach ($arrRow as $key => $varValue) {
$objDc = new \DC_Table($this->linkedTable);
$objDc->activeRecord = $objDbResult;
$objDc->id = $objDbResult->id;
$varValue = $this->localizeFields ? FormSubmission::prepareSpecialValueForPrint($varValue, $arrDca['fields'][$key], $this->linkedTable, $objDc) : $varValue;
if (is_array($varValue)) {
$varValue = Arrays::flattenArray($varValue);
}
$this->objPhpExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($intCol, $intRow, html_entity_decode($varValue));
$this->objPhpExcel->getActiveSheet()->getColumnDimension(\PHPExcel_Cell::stringFromColumnIndex($intCol))->setAutoSize(true);
$this->processBodyRow($intCol);
$intCol++;
}
$this->objPhpExcel->getActiveSheet()->getRowDimension($intRow)->setRowHeight(-1);
$intRow++;
}
$this->objPhpExcel->setActiveSheetIndex(0);
$this->objPhpExcel->getActiveSheet()->setTitle('Export');
return $this->objPhpExcel;
break;
}
return false;
}
public static function prepareSpecialValueForPrint($varValue, $arrData, $strTable, $objDc, $objItem = null)
{
$varValue = deserialize($varValue);
$arrOpts = $arrData['options'];
$arrReference = $arrData['reference'];
$strRegExp = $arrData['eval']['rgxp'];
// get options
if ((is_array($arrData['options_callback']) || is_callable($arrData['options_callback'])) && !$arrData['reference']) {
if (is_array($arrData['options_callback'])) {
$strClass = $arrData['options_callback'][0];
$strMethod = $arrData['options_callback'][1];
$objInstance = \Controller::importStatic($strClass);
$arrOptionsCallback = @$objInstance->{$strMethod}($objDc);
} elseif (is_callable($arrData['options_callback'])) {
$arrOptionsCallback = @$arrData['options_callback']($objDc);
}
$arrOptions = !is_array($varValue) ? array($varValue) : $varValue;
if ($varValue !== null && is_array($arrOptionsCallback)) {
$varValue = array_intersect_key($arrOptionsCallback, array_flip($arrOptions));
}
}
if ($arrData['inputType'] == 'explanation') {
$varValue = $arrData['eval']['text'];
} elseif ($strRegExp == 'date') {
$varValue = \Date::parse(\Config::get('dateFormat'), $varValue);
} elseif ($strRegExp == 'time') {
$varValue = \Date::parse(\Config::get('timeFormat'), $varValue);
} elseif ($strRegExp == 'datim') {
$varValue = \Date::parse(\Config::get('datimFormat'), $varValue);
} elseif ($arrData['inputType'] == 'tag' && in_array('tags_plus', \ModuleLoader::getActive())) {
if (($arrTags = \HeimrichHannot\TagsPlus\TagsPlus::loadTags($strTable, $objItem->id)) !== null) {
$varValue = $arrTags;
}
} elseif (!is_array($varValue) && \Validator::isBinaryUuid($varValue)) {
$strPath = Files::getPathFromUuid($varValue);
$varValue = $strPath ? \Environment::get('url') . '/' . $strPath : \StringUtil::binToUuid($varValue);
} elseif (is_array($varValue)) {
$varValue = Arrays::flattenArray($varValue);
$varValue = array_filter($varValue);
// remove empty elements
// transform binary uuids to paths
$varValue = array_map(function ($varValue) {
if (\Validator::isBinaryUuid($varValue)) {
$strPath = Files::getPathFromUuid($varValue);
if ($strPath) {
return \Environment::get('url') . '/' . $strPath;
}
return \StringUtil::binToUuid($varValue);
}
return $varValue;
}, $varValue);
if (!$arrReference) {
$varValue = array_map(function ($varValue) use($arrOpts) {
return isset($arrOpts[$varValue]) ? $arrOpts[$varValue] : $varValue;
}, $varValue);
}
$varValue = array_map(function ($varValue) use($arrReference) {
if (is_array($arrReference)) {
return isset($arrReference[$varValue]) ? is_array($arrReference[$varValue]) ? $arrReference[$varValue][0] : $arrReference[$varValue] : $varValue;
} else {
return $varValue;
}
}, $varValue);
} else {
if ($arrData['eval']['isBoolean'] || $arrData['inputType'] == 'checkbox' && !$arrData['eval']['multiple']) {
$varValue = $varValue != '' ? $GLOBALS['TL_LANG']['MSC']['yes'] : $GLOBALS['TL_LANG']['MSC']['no'];
} elseif (is_array($arrOpts) && array_is_assoc($arrOpts)) {
$varValue = isset($arrOpts[$varValue]) ? $arrOpts[$varValue] : $varValue;
} elseif (is_array($arrReference)) {
$varValue = isset($arrReference[$varValue]) ? is_array($arrReference[$varValue]) ? $arrReference[$varValue][0] : $arrReference[$varValue] : $varValue;
}
}
if (is_array($varValue)) {
$varValue = implode(', ', $varValue);
}
// Convert special characters (see #1890)
return specialchars($varValue);
}
