--- /dev/null
+[% USE HTML %][% USE L %][% USE LxERP %]
+
+<h1>[% FORM.title %]</h1>
+
+[%- INCLUDE 'common/flash.html' %]
+
+<form method="post" action="controller.pl" id="form">
+ [% L.hidden_tag("id", SELF.query.id) %]
+ [% L.hidden_tag("format", "csv") %]
+
+ [% IF !SELF.parameters.size %]
+ <p>
+ [% LxERP.t8("The SQL query does not contain any parameter that need to be configured.") %]
+ </p>
+
+ [% ELSE %]
+
+ <table>
+ <thead>
+ <tr class="listheading">
+ <th>[% LxERP.t8("Variable Name") %]</th>
+ <th>[% LxERP.t8("Type") %]</th>
+ <th>[% LxERP.t8("Value") %]</th>
+ <th>[% LxERP.t8("Description") %]</th>
+ </tr>
+ </thead>
+
+ <tbody>
+ [% FOREACH parameter = SELF.parameters %]
+ <tr class="listrow">
+ <td>
+ [% HTML.escape(parameter.name) %]
+ </td>
+
+ [% SET value = parameter.calculate_default_value %]
+
+ [% IF parameter.parameter_type == "number" %]
+ <td>[% LxERP.t8("Number") %]</td>
+ <td>[% L.input_tag("parameters." _ parameter.name, value, style="width: 300px", "data-validate"="required") %]</td>
+
+ [% ELSIF parameter.parameter_type == "date" %]
+ <td>[% LxERP.t8("Date") %]</td>
+ <td>[% L.date_tag("parameters." _ parameter.name, value, style="width: 300px", "data-validate"="required") %]</td>
+
+ [% ELSE %]
+ <td>[% LxERP.t8("Text") %]</td>
+ <td>[% L.input_tag("parameters." _ parameter.name, value, style="width: 300px", "data-validate"="required") %]</td>
+ [% END %]
+
+ <td>[% HTML.escape(parameter.description) %]</td>
+ </tr>
+ [% END %]
+ </tbody>
+ [% END %]
+</form>