From 911eb44f4a4b22350aee391c4d08ee73b040caae Mon Sep 17 00:00:00 2001
From: eileen <emcnaughton@wikimedia.org>
Date: Tue, 14 Aug 2018 12:14:29 +1200
Subject: [PATCH] Add SQL modes to developer tab

---
 CRM/Report/Form.php                          | 2 ++
 templates/CRM/Report/Form/Tabs/Developer.tpl | 7 ++++++-
 2 files changed, 8 insertions(+), 1 deletion(-)

diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php
index f3dbf456e8..a8955408ee 100644
--- a/CRM/Report/Form.php
+++ b/CRM/Report/Form.php
@@ -1411,6 +1411,8 @@ class CRM_Report_Form extends CRM_Core_Form {
       $this->sqlFormattedArray[] = $sql;
       $this->assign('sql', implode(';<br><br><br><br>', $this->sqlFormattedArray));
     }
+    $this->assign('sqlModes', $sqlModes = CRM_Utils_SQL::getSqlModes());
+
   }
 
   /**
diff --git a/templates/CRM/Report/Form/Tabs/Developer.tpl b/templates/CRM/Report/Form/Tabs/Developer.tpl
index dd2f3a195d..67e814ad53 100644
--- a/templates/CRM/Report/Form/Tabs/Developer.tpl
+++ b/templates/CRM/Report/Form/Tabs/Developer.tpl
@@ -1,4 +1,9 @@
 <div id="report-tab-set-developer" class="civireport-criteria">
-  <p><b>{ts}Class used{/ts}: {$report_class}</b></p>
+  <p><b>{ts}Class used{/ts}: {$report_class|escape}</b></p>
+  <p>{ts}SQL Modes{/ts}:
+  {foreach from=$sqlModes item=sqlMode}
+    {$sqlMode|escape}
+  {/foreach}
+  </p>
   <pre>{$sql|purify}</pre>
 </div>
-- 
2.25.1