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 |
|