/** * Help render mr_report_abstract SQL * * @param mr_report_abstract $report mr_report_abstract instance * @return string */ public function help_render_mr_report_sql(mr_report_abstract $report) { global $CFG, $USER; $output = ''; $executedsql = $report->get_executedsql(); $usernames = array('mrsupport', 'mrdev'); if (!empty($CFG->reportviewsql) and is_array($CFG->reportviewsql)) { $usernames = array_merge($usernames, $CFG->reportviewsql); } if (in_array($USER->username, $usernames) and !empty($executedsql)) { $sql = ''; foreach ($executedsql as $values) { list($rawsql, $params) = $values; $rawsql = trim($rawsql); $sql .= s($rawsql) . "\n\n"; if (!is_null($params)) { $sql .= s(var_export($params, true)) . "\n\n\n"; } } $output = print_collapsible_region($this->output->box('<pre>' . trim($sql) . '</pre>', ''), 'generalbox mr_report_sql', 'mr_report_sql_id', get_string('reportsql', 'local_mr'), 'mr_report_sql_toggle', false, true); } return $output; }