/** * Bulk export: "spreadsheet" export: a simplified HTML export in which the date/time columns are split in two column: date AND time * * @copyright Copyright (C) 2015 Combodo SARL * @license http://opensource.org/licenses/AGPL-3.0 */ class SpreadsheetBulkExport extends TabularBulkExport { public function DisplayUsage(Page $oP) { $oP->p(" * spreadsheet format options:"); $oP->p(" *\tfields: (mandatory) the comma separated list of field codes to export (e.g: name,org_id,service_name...)."); $oP->p(" *\tno_localize: (optional) pass 1 to retrieve the raw (untranslated) values for enumerated fields. Default: 0."); } public function EnumFormParts() { return array_merge(parent::EnumFormParts(), array('spreadsheet_options' => array('no-localize') ,'interactive_fields_spreadsheet' => array('interactive_fields_spreadsheet'))); } public function DisplayFormPart(WebPage $oP, $sPartId) { switch($sPartId) { case 'interactive_fields_spreadsheet': $this->GetInteractiveFieldsWidget($oP, 'interactive_fields_spreadsheet'); break; case 'spreadsheet_options': $sChecked = (utils::ReadParam('no_localize', 0) == 1) ? ' checked ' : ''; $oP->add('
'); break; default: return parent:: DisplayFormPart($oP, $sPartId); } } public function ReadParameters() { parent::ReadParameters(); $this->aStatusInfo['localize'] = (utils::ReadParam('no_localize', 0) != 1); } protected function GetSampleData(DBObject $oObj, $sAttCode) { return $oObj->GetAsHTML($sAttCode); } public function GetHeader() { $oSet = new DBObjectSet($this->oSearch); $this->aStatusInfo['status'] = 'running'; $this->aStatusInfo['position'] = 0; $this->aStatusInfo['total'] = $oSet->Count(); $aSelectedClasses = $this->oSearch->GetSelectedClasses(); $aData = array(); foreach($this->aStatusInfo['fields'] as $sExtendedAttCode) { if (preg_match('/^([^\.]+)\.(.+)$/', $sExtendedAttCode, $aMatches)) { $sAlias = $aMatches[1]; $sAttCode = $aMatches[2]; } else { $sAlias = reset($aSelectedClasses); $sAttCode = $sExtendedAttCode; } if (!array_key_exists($sAlias, $aSelectedClasses)) { throw new Exception("Invalid alias '$sAlias' for the column '$sExtendedAttCode'. Availables aliases: '".implode("', '", array_keys($aSelectedClasses))."'"); } $sClass = $aSelectedClasses[$sAlias]; switch($sAttCode) { case 'id': if (count($aSelectedClasses) > 1) { $aData[] = $sAlias.'.id'; //@@@ } else { $aData[] = 'id'; //@@@ } break; default: $oAttDef = MetaModel::GetAttributeDef($sClass, $sAttCode); $sColLabel = $this->aStatusInfo['localize'] ? MetaModel::GetLabel($sClass, $sAttCode) : $sAttCode; $oFinalAttDef = $oAttDef->GetFinalAttDef(); if (get_class($oFinalAttDef) == 'AttributeDateTime') { if (count($aSelectedClasses) > 1) { $aData[] = $sAlias.'.'.$sColLabel.' ('.Dict::S('UI:SplitDateTime-Date').')'; $aData[] = $sAlias.'.'.$sColLabel.' ('.Dict::S('UI:SplitDateTime-Time').')'; } else { $aData[] = $sColLabel.' ('.Dict::S('UI:SplitDateTime-Date').')'; $aData[] = $sColLabel.' ('.Dict::S('UI:SplitDateTime-Time').')'; } } else { if (count($aSelectedClasses) > 1) { $aData[] = $sAlias.'.'.$sColLabel; } else { $aData[] = $sColLabel; } } } } $sData = "".$sLabel." | \n"; } $sData .= "|||||
$sField | "; continue; } switch($aAttCode['attcode']) { case 'id': $sField = $oObj->GetName(); $sData .= "$sField | "; break; default: $oAttDef = MetaModel::GetAttributeDef(get_class($oObj), $aAttCode['attcode']); $oFinalAttDef = $oAttDef->GetFinalAttDef(); if (get_class($oFinalAttDef) == 'AttributeDateTime') { $iDate = AttributeDateTime::GetAsUnixSeconds($oObj->Get($aAttCode['attcode'])); $sData .= ''.date('Y-m-d', $iDate).' | '; // Add the first column directly $sField = date('H:i:s', $iDate); // Will add the second column below $sData .= "$sField | "; } else if($oAttDef instanceof AttributeCaseLog) { $rawValue = $oObj->Get($aAttCode['attcode']); $sField = str_replace("\n", "$sField | "; } else { $rawValue = $oObj->Get($aAttCode['attcode']); // Due to custom formatting rules, empty friendlynames may be rendered as non-empty strings // let's fix this and make sure we render an empty string if the key == 0 if ($oAttDef instanceof AttributeFriendlyName) { $sKeyAttCode = $oAttDef->GetKeyAttCode(); if ($sKeyAttCode != 'id') { if ($oObj->Get($sKeyAttCode) == 0) { $sValue = ''; } } } if ($this->aStatusInfo['localize']) { $sField = htmlentities($oFinalAttDef->GetEditValue($rawValue), ENT_QUOTES, 'UTF-8'); } else { $sField = htmlentities($rawValue, ENT_QUOTES, 'UTF-8'); } $sData .= "$sField | "; } } } $sData .= "