/** * Bulk export: HTML export * * @copyright Copyright (C) 2015 Combodo SARL * @license http://opensource.org/licenses/AGPL-3.0 */ class HTMLBulkExport extends TabularBulkExport { public function DisplayUsage(Page $oP) { $oP->p(" * html format options:"); $oP->p(" *\tfields: (mandatory) the comma separated list of field codes to export (e.g: name,org_id,service_name...)."); } public function EnumFormParts() { return array_merge(parent::EnumFormParts(), array('interactive_fields_html' => array('interactive_fields_html'))); } public function DisplayFormPart(WebPage $oP, $sPartId) { switch($sPartId) { case 'interactive_fields_html': $this->GetInteractiveFieldsWidget($oP, 'interactive_fields_html'); break; default: return parent:: DisplayFormPart($oP, $sPartId); } } protected function GetSampleData($oObj, $sAttCode) { if ($sAttCode != 'id') { $oAttDef = MetaModel::GetAttributeDef(get_class($oObj), $sAttCode); if ($oAttDef instanceof AttributeDateTime) // AttributeDate is derived from AttributeDateTime { $sClass = (get_class($oAttDef) == 'AttributeDateTime') ? 'user-formatted-date-time' : 'user-formatted-date'; return '
'.htmlentities($oAttDef->GetEditValue($oObj->Get($sAttCode), $oObj), ENT_QUOTES, 'UTF-8').'
'; } } return $this->GetValue($oObj, $sAttCode); } protected function GetValue($oObj, $sAttCode) { switch($sAttCode) { case 'id': $sRet = $oObj->GetHyperlink(); break; default: $value = $oObj->Get($sAttCode); if ($value instanceof ormCaseLog) { $sRet = $value->GetAsSimpleHtml(); } elseif ($value instanceof ormStopWatch) { $sRet = $value->GetTimeSpent(); } else { $sRet = $oObj->GetAsHtml($sAttCode); } } return $sRet; } public function GetHeader() { $sData = ''; $oSet = new DBObjectSet($this->oSearch); $this->aStatusInfo['status'] = 'running'; $this->aStatusInfo['position'] = 0; $this->aStatusInfo['total'] = $oSet->Count(); $sData .= "\n"; $sData .= "\n"; $sData .= "\n"; foreach($this->aStatusInfo['fields'] as $iCol => $aFieldSpec) { $sData .= "\n"; } $sData .= "\n"; $sData .= "\n"; $sData .= "\n"; return $sData; } public function GetNextChunk(&$aStatus) { $sRetCode = 'run'; $iPercentage = 0; $oSet = new DBObjectSet($this->oSearch); $oSet->SetLimit($this->iChunkSize, $this->aStatusInfo['position']); $this->OptimizeColumnLoad($oSet); $sFirstAlias = $this->oSearch->GetClassAlias(); $iCount = 0; $sData = ''; $iPreviousTimeLimit = ini_get('max_execution_time'); $iLoopTimeLimit = MetaModel::GetConfig()->Get('max_execution_time_per_loop'); while($aRow = $oSet->FetchAssoc()) { set_time_limit($iLoopTimeLimit); $oMainObj = $aRow[$sFirstAlias]; $sHilightClass = ''; if ($oMainObj) { $sHilightClass = $aRow[$sFirstAlias]->GetHilightClass(); } if ($sHilightClass != '') { $sData .= ""; } else { $sData .= ""; } foreach($this->aStatusInfo['fields'] as $iCol => $aFieldSpec) { $sAlias = $aFieldSpec['sAlias']; $sAttCode = $aFieldSpec['sAttCode']; $oObj = $aRow[$sAlias]; $sField = ''; if ($oObj) { $sField = $this->GetValue($oObj, $sAttCode); } $sValue = ($sField === '') ? ' ' : $sField; $sData .= ""; } $sData .= ""; $iCount++; } set_time_limit($iPreviousTimeLimit); $this->aStatusInfo['position'] += $this->iChunkSize; if ($this->aStatusInfo['total'] == 0) { $iPercentage = 100; } else { $iPercentage = floor(min(100.0, 100.0*$this->aStatusInfo['position']/$this->aStatusInfo['total'])); } if ($iCount < $this->iChunkSize) { $sRetCode = 'done'; } $aStatus = array('code' => $sRetCode, 'message' => Dict::S('Core:BulkExport:RetrievingData'), 'percentage' => $iPercentage); return $sData; } public function GetFooter() { $sData = "\n"; $sData .= "
".$aFieldSpec['sColLabel']."
$sValue
\n"; return $sData; } public function GetSupportedFormats() { return array('html' => Dict::S('Core:BulkExport:HTMLFormat')); } public function GetMimeType() { return 'text/html'; } public function GetFileExtension() { return 'html'; } }