$oP->p("Error the query can not be executed."); if ($e instanceof CoreException) { $oP->p($e->GetHtmlDesc()); } else { $oP->p($e->getMessage()); } } } if (!$oP) { // Display a short message about how to use this page $bModeCLI = utils::IsModeCLI(); if ($bModeCLI) { $oP = new CLIPage("iTop - Export"); } else { $oP = new WebPage("iTop - Export"); } $oP->p("General purpose export page."); $oP->p("Parameters:"); $oP->p(" * expression: an OQL expression (URL encoded if needed)"); $oP->p(" * query: (alternative to 'expression') the id of an entry from the query phrasebook"); $oP->p(" * arg_xxx: (needed if the query has parameters) the value of the parameter 'xxx'"); $oP->p(" * format: (optional, default is html) the desired output format. Can be one of 'html', 'spreadsheet', 'csv', 'xlsx' or 'xml'"); $oP->p(" * fields: (optional, no effect on XML format) list of fields (attribute codes, or alias.attcode) separated by a coma"); $oP->p(" * fields_advanced: (optional, no effect on XML/HTML formats ; ignored is fields is specified) If set to 1, the default list of fields will include the external keys and their reconciliation keys"); $oP->p(" * filename: (optional, no effect in CLI mode) if set then the results will be downloaded as a file"); } if ($sFileName != '') { $oP->add_header('Content-Disposition: attachment; filename="' . $sFileName . '"'); } $oP->TrashUnexpectedOutput(); $oP->output();
public function SetHttpHeaders(WebPage $oPage) { // Integration within MS-Excel web queries + HTTPS + IIS: // MS-IIS set these header values with no-cache... while Excel fails to do the job if using HTTPS // Then the fix is to force the reset of header values Pragma and Cache-control $oPage->add_header("Pragma:", true); $oPage->add_header("Cache-control:", true); }