From fab0b24d2465ed68c31cc62d6093723531dc5ce0 Mon Sep 17 00:00:00 2001
From: Philip Orr <philip.orr@lmscloud.de>
Date: Fri, 31 Mar 2023 07:12:48 +0000
Subject: [PATCH] Bug 27513: Add notes to variables for report parameters
 template

This patch adds the TT variable 'notes' to the variables
that guided_reports.pl passes to the template guided_reports_start.tt
during SQL parameters entry in the phase 'Run this report'.

To test:
1. apply the patch
2. navigate to Reports -> Guided Reports -> Create from SQL
3. create an SQL report that includes at least one parameter, e.g.:
   SELECT barcode FROM items WHERE homebranch=<<Select library|branches>>
   the actual SQL and name of the report doesn't matter much, just make
   sure that you also put a note e.g. "Test text for display" in the
   field "Notes:" before you save the report.
4. run the report
5. the note you entered should now be displayed below the heading
   "Enter parameters for report..."

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit fa534d464c63739f4c836a43966802caa09b0ca8)
Signed-off-by: Jacob O'Mara <jacobomara901@gmail.com>
(cherry picked from commit 5de9cb41df412317ee4d907502043cc00530aceb)
Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
---
 reports/guided_reports.pl | 1 +
 1 file changed, 1 insertion(+)

diff --git a/reports/guided_reports.pl b/reports/guided_reports.pl
index 7a04d8a360..6fda5966ea 100755
--- a/reports/guided_reports.pl
+++ b/reports/guided_reports.pl
@@ -838,6 +838,7 @@ elsif ($phase eq 'Run this report'){
             }
             $template->param('sql'         => $sql,
                             'name'         => $name,
+                            'notes'         => $notes,
                             'sql_params'   => \@tmpl_parameters,
                             'auth_val_errors'  => \@authval_errors,
                             'enter_params' => 1,
-- 
2.39.5