View | Details | Raw Unified | Return to bug 5698
Collapse All | Expand All

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt (-1 / +15 lines)
Lines 486-492 canned reports and writing custom SQL reports.</p> Link Here
486
        <h1>Enter parameters for report [% name %]:</h1>
486
        <h1>Enter parameters for report [% name %]:</h1>
487
        [% IF ( notes ) %]<p>[% notes %]</p>[% END %]
487
        [% IF ( notes ) %]<p>[% notes %]</p>[% END %]
488
        [% FOREACH sql_param IN sql_params %]
488
        [% FOREACH sql_param IN sql_params %]
489
            <p>[% sql_param.entry %]: [% sql_param.input %]</p>
489
            [% IF sql_param.input == 'date' %]
490
                <p>
491
                [% sql_param.entry %]: <input id="date_[% sql_param_entry %]" type="text" value="" size="10" name="sql_params">
492
                <img id="date_picker_[% sql_param_entry %]" alt="Show Calendar" src="/intranet-tmpl/prog/en/lib/calendar/cal.gif">
493
                <script type="text/javascript">
494
                      Calendar.setup( {
495
                         inputField : "date_[% sql_param_entry %]",
496
                         ifFormat : "%Y-%m-%d",
497
                         button : "date_picker_[% sql_param_entry %]"
498
                      } );
499
                </script>
500
                </p>
501
            [% ELSE %]
502
                <p>[% sql_param.entry %]: [% sql_param.input %]</p>
503
            [% END %]
490
        [% END %]
504
        [% END %]
491
        <input type='submit' value='Run the report'/>
505
        <input type='submit' value='Run the report'/>
492
    </form>
506
    </form>
(-)a/reports/guided_reports.pl (-13 / +1 lines)
Lines 421-438 elsif ($phase eq 'Run this report'){ Link Here
421
            my ($text,$authorised_value) = split /\|/,$split[$i*2+1];
421
            my ($text,$authorised_value) = split /\|/,$split[$i*2+1];
422
            my $input;
422
            my $input;
423
            if ($authorised_value eq "date") {
423
            if ($authorised_value eq "date") {
424
               $input = qq(<input id="date_$text" type="text" value="" size="10" name="sql_params">
424
               $input = 'date';
425
                         <img id="date_picker_$text" alt="Show Calendar" src="/intranet-tmpl/prog/en/lib/calendar/cal.gif">
426
                         <script type="text/javascript">
427
                              Calendar.setup(
428
                              {
429
                                 inputField : "date_$text",
430
                                 ifFormat : "%Y-%m-%d",
431
                                 button : "date_picker_$text"
432
                              }
433
                              );
434
                         </script>
435
                         );
436
            }
425
            }
437
            elsif ($authorised_value) {
426
            elsif ($authorised_value) {
438
                my $dbh=C4::Context->dbh;
427
                my $dbh=C4::Context->dbh;
439
- 

Return to bug 5698