|
Lines 487-510
canned reports and writing custom SQL reports.</p>
Link Here
|
| 487 |
<input type='hidden' name='reports' value="[% reports %]" /> |
487 |
<input type='hidden' name='reports' value="[% reports %]" /> |
| 488 |
<h1>Enter parameters for report [% name %]:</h1> |
488 |
<h1>Enter parameters for report [% name %]:</h1> |
| 489 |
[% IF ( notes ) %]<p>[% notes %]</p>[% END %] |
489 |
[% IF ( notes ) %]<p>[% notes %]</p>[% END %] |
|
|
490 |
<fieldset class="rows"> |
| 491 |
<ol> |
| 490 |
[% FOREACH sql_param IN sql_params %] |
492 |
[% FOREACH sql_param IN sql_params %] |
| 491 |
[% IF sql_param.input == 'date' %] |
493 |
[% IF sql_param.input == 'date' %] |
| 492 |
<p> |
494 |
<li><label for="date_[% sql_param_entry %][% loop.count %]"> |
| 493 |
[% sql_param.entry %]: <input id="date_[% sql_param_entry %]" type="text" value="" size="10" name="sql_params"> |
495 |
[% sql_param.entry %]:</label> <input id="date_[% sql_param_entry %][% loop.count %]" type="text" value="" size="10" name="sql_params" /> |
| 494 |
<img id="date_picker_[% sql_param_entry %]" alt="Show calendar" src="/intranet-tmpl/prog/en/lib/calendar/cal.gif"> |
496 |
<img id="date_picker_[% sql_param_entry %][% loop.count %]" alt="Show calendar" src="/intranet-tmpl/prog/en/lib/calendar/cal.gif" /> |
| 495 |
<script type="text/javascript"> |
497 |
<script type="text/javascript"> |
| 496 |
Calendar.setup( { |
498 |
Calendar.setup( { |
| 497 |
inputField : "date_[% sql_param_entry %]", |
499 |
inputField : "date_[% sql_param_entry %][% loop.count %]", |
| 498 |
ifFormat : "%Y-%m-%d", |
500 |
ifFormat : "%Y-%m-%d", |
| 499 |
button : "date_picker_[% sql_param_entry %]" |
501 |
button : "date_picker_[% sql_param_entry %][% loop.count %]" |
| 500 |
} ); |
502 |
} ); |
| 501 |
</script> |
503 |
</script> |
| 502 |
</p> |
504 |
</li> |
|
|
505 |
[% ELSIF ( sql_param.input == 'text' ) %] |
| 506 |
<li><label for="sql_params[% loop.count %]">[% sql_param.entry %]: </label><input id="sql_params[% loop.count %]" type="text" name="sql_params" /></li> |
| 503 |
[% ELSE %] |
507 |
[% ELSE %] |
| 504 |
<p>[% sql_param.entry %]: [% sql_param.input %]</p> |
508 |
<li><label for="sql_params_[% sql_param.labelid %]">[% sql_param.entry %]:</label> [% sql_param.input %]</li> |
| 505 |
[% END %] |
509 |
[% END %] |
| 506 |
[% END %] |
510 |
[% END %] |
| 507 |
<input type='submit' value='Run the report'/> |
511 |
</ol> |
|
|
512 |
</fieldset> |
| 513 |
<fieldset class="action"><input type="submit" value="Run the report"/></fieldset> |
| 508 |
</form> |
514 |
</form> |
| 509 |
[% END %] |
515 |
[% END %] |
| 510 |
|
516 |
|