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

(-)a/C4/Serials.pm (+4 lines)
Lines 510-515 The valid search fields are: Link Here
510
  branch
510
  branch
511
  expiration_date
511
  expiration_date
512
  closed
512
  closed
513
  routinglist
513
514
514
The expiration_date search field is special; it specifies the maximum
515
The expiration_date search field is special; it specifies the maximum
515
subscription expiration date.
516
subscription expiration date.
Lines 553-558 sub SearchSubscriptions { Link Here
553
            LEFT JOIN biblioitems ON biblioitems.biblionumber = subscription.biblionumber
554
            LEFT JOIN biblioitems ON biblioitems.biblionumber = subscription.biblionumber
554
            LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
555
            LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
555
    |;
556
    |;
557
    if( $args->{routinglist} ) {
558
        $query .= q| LEFT JOIN subscriptionroutinglist ON subscriptionroutinglist.subscriptionid = subscription.subscriptionid|;
559
    }
556
    $query .= q| WHERE 1|;
560
    $query .= q| WHERE 1|;
557
    my @where_strs;
561
    my @where_strs;
558
    my @where_args;
562
    my @where_args;
(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/serials-advsearch.inc (+5 lines)
Lines 50-55 Link Here
50
                    <label for="to">Expires before:</label>
50
                    <label for="to">Expires before:</label>
51
                    <input type="text" id="to" name="expiration_date_filter" value="[% expiration_date_filter | html %]" size="10" maxlength="10" class="flatpickr" />
51
                    <input type="text" id="to" name="expiration_date_filter" value="[% expiration_date_filter | html %]" size="10" maxlength="10" class="flatpickr" />
52
                </li>
52
                </li>
53
                <li class="local">
54
                        <label for="routinglist">Search routing lists only:</label>
55
                        <input type="checkbox" id="routinglist" name="routinglist" />
56
                </li>
57
53
                [% INCLUDE 'additional-fields-entry.inc' available=additional_fields_for_subscription values=additional_field_filters wrap_fieldset=0 %]
58
                [% INCLUDE 'additional-fields-entry.inc' available=additional_fields_for_subscription values=additional_field_filters wrap_fieldset=0 %]
54
            </ol>
59
            </ol>
55
            <input type="hidden" name="searched" value="1" />
60
            <input type="hidden" name="searched" value="1" />
(-)a/serials/serials-search.pl (-1 / +2 lines)
Lines 52-57 my $location = $query->param('location_filter') || ''; Link Here
52
my $expiration_date = $query->param('expiration_date_filter') || '';
52
my $expiration_date = $query->param('expiration_date_filter') || '';
53
my $routing       = $query->param('routing') || C4::Context->preference("RoutingSerials");
53
my $routing       = $query->param('routing') || C4::Context->preference("RoutingSerials");
54
my $searched      = $query->param('searched') || 0;
54
my $searched      = $query->param('searched') || 0;
55
my $routinglist   = $query->param('routinglist');
55
my $mana      = $query->param('mana') || 0;
56
my $mana      = $query->param('mana') || 0;
56
my @subscriptionids = $query->multi_param('subscriptionid');
57
my @subscriptionids = $query->multi_param('subscriptionid');
57
my $op            = $query->param('op');
58
my $op            = $query->param('op');
Lines 116-121 if ($searched) { Link Here
116
                additional_fields => \@additional_field_filters,
117
                additional_fields => \@additional_field_filters,
117
                location     => $location,
118
                location     => $location,
118
                expiration_date => $expiration_date,
119
                expiration_date => $expiration_date,
120
                routinglist     => $routinglist,
119
            },
121
            },
120
            { results_limit => C4::Context->preference('SerialsSearchResultsLimit') }
122
            { results_limit => C4::Context->preference('SerialsSearchResultsLimit') }
121
        );
123
        );
122
- 

Return to bug 26567