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

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tt (-1 / +1 lines)
Lines 62-68 Link Here
62
<ul>
62
<ul>
63
<li>The &lt;&lt; and &gt;&gt; are just delimiters. You must put &lt;&lt; at the beginning and &gt;&gt; at the end of your parameter</li>
63
<li>The &lt;&lt; and &gt;&gt; are just delimiters. You must put &lt;&lt; at the beginning and &gt;&gt; at the end of your parameter</li>
64
<li>The <strong>Question to ask</strong> will be displayed on the left of the string to enter. 
64
<li>The <strong>Question to ask</strong> will be displayed on the left of the string to enter. 
65
<li>The <strong>authorised_value</strong> can be omitted if not applicable. If it contains an authorised value category, or <strong>branches</strong> or <strong>itemtype</strong> or <strong>categorycode</strong>, a list with the Koha authorised values will be displayed instead of a free field</li>
65
<li>The <strong>authorised_value</strong> can be omitted if not applicable. If it contains an authorised value category, or <strong>branches</strong> or <strong>itemtype</strong> or <strong>categorycode</strong>, a list with the Koha authorised values will be displayed instead of a free field.  If the authorised value is <strong>date</strong>, a date selector button will be added after the input field</li>
66
</ul>
66
</ul>
67
67
68
<p>Note that you can have more than one parameter in a given SQL</p>
68
<p>Note that you can have more than one parameter in a given SQL</p>
(-)a/reports/guided_reports.pl (-2 / +15 lines)
Lines 420-426 elsif ($phase eq 'Run this report'){ Link Here
420
        for(my $i=0;$i<($#split/2);$i++) {
420
        for(my $i=0;$i<($#split/2);$i++) {
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) {
423
            if ($authorised_value eq "date") {
424
               $input = qq(<input id="date_$text" type="text" value="" size="10" name="sql_params">
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
            }
437
            elsif ($authorised_value) {
424
                my $dbh=C4::Context->dbh;
438
                my $dbh=C4::Context->dbh;
425
                my @authorised_values;
439
                my @authorised_values;
426
                my %authorised_lib;
440
                my %authorised_lib;
427
- 

Return to bug 5698