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

(-)a/Koha/AdditionalField.pm (-1 / +1 lines)
Lines 230-236 sub get_matching_record_ids { Link Here
230 
        ) AS values$i |;
 230 
        ) AS values$i |;
231 
        $subquery .= ' USING (record_id)' if $i > 1;
 231 
        $subquery .= ' USING (record_id)' if $i > 1;
232 
        push @subqueries, $subquery;
 232 
        push @subqueries, $subquery;
233 
        push @args, $field->{name}, $tablename, ( $exact_match ? $field->{value} : "%$field->{value}%" );
 233 
        push @args, $field->{name}, $tablename, ( $exact_match or $field->{authorised_value_category} ? $field->{value} : "%$field->{value}%" );
234 
    }
 234 
    }
235 
    $query .= join( ' LEFT JOIN ', @subqueries ) . ' WHERE 1';
 235 
    $query .= join( ' LEFT JOIN ', @subqueries ) . ' WHERE 1';
236 
    for my $j ( 1 .. $i ) {
 236 
    for my $j ( 1 .. $i ) {
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-search.tt (-2 / +2 lines)
Lines 425-431 Link Here
425 
                      <select id="additional_field_[% field.id %]" name="additional_field_[% field.id %]_filter">
 425 
                      <select id="additional_field_[% field.id %]" name="additional_field_[% field.id %]_filter">
426 
                        <option value="">All</option>
 426 
                        <option value="">All</option>
427 
                        [% FOREACH av IN field.authorised_value_choices %]
 427 
                        [% FOREACH av IN field.authorised_value_choices %]
428 
                          [% IF av.authorised_value == additional_field_filters.${field.name} %]
 428 
                          [% IF av.authorised_value == additional_field_filters.${field.name}.value %]
429 
                            <option value="[% av.authorised_value %]" selected="selected">[% av.lib %]</option>
 429 
                            <option value="[% av.authorised_value %]" selected="selected">[% av.lib %]</option>
430 
                          [% ELSE %]
 430 
                          [% ELSE %]
431 
                            <option value="[% av.authorised_value %]">[% av.lib %]</option>
 431 
                            <option value="[% av.authorised_value %]">[% av.lib %]</option>
Lines 433-439 Link Here
433 
                        [% END %]
 433 
                        [% END %]
434 
                      </select>
 434 
                      </select>
435 
                    [% ELSE %]
 435 
                    [% ELSE %]
436 
                      <input id="additional_field_[% field.id %]" type="text" value="[% additional_field_filters.${field.name} %]" name="additional_field_[% field.id %]_filter" />
 436 
                      <input id="additional_field_[% field.id %]" type="text" value="[% additional_field_filters.${field.name}.value %]" name="additional_field_[% field.id %]_filter" />
437 
                    [% END %]
 437 
                    [% END %]
438 
                  </li>
 438 
                  </li>
439 
                [% END %]
 439 
                [% END %]
(-)a/serials/serials-search.pl (-4 / +6 lines)
Lines 82-89 my $additional_fields = Koha::AdditionalField->all( { tablename => 'subscription Link Here
82 
my $additional_field_filters;
 82 
my $additional_field_filters;
83 
for my $field ( @$additional_fields ) {
 83 
for my $field ( @$additional_fields ) {
84 
    my $filter_value = $query->param('additional_field_' . $field->{id} . '_filter');
 84 
    my $filter_value = $query->param('additional_field_' . $field->{id} . '_filter');
85 
    if ( defined ( $filter_value ) ) {
 85 
    if ( defined $filter_value and $filter_value ne q|| ) {
86 
        $additional_field_filters->{ $field->{name} } = $filter_value;
 86 
        $additional_field_filters->{ $field->{name} } = {
87 
            value => $filter_value,
88 
            authorised_value_category => $field->{authorised_value_category},
89 
        };
87 
    }
 90 
    }
88 
    if ( $field->{authorised_value_category} ) {
 91 
    if ( $field->{authorised_value_category} ) {
89 
        $field->{authorised_value_choices} = GetAuthorisedValues( $field->{authorised_value_category} );
 92 
        $field->{authorised_value_choices} = GetAuthorisedValues( $field->{authorised_value_category} );
Lines 103-109 if ($searched){ Link Here
103 
            publisher    => $publisher,
 106 
            publisher    => $publisher,
104 
            bookseller   => $bookseller,
 107 
            bookseller   => $bookseller,
105 
            branch       => $branch,
 108 
            branch       => $branch,
106 
            additional_fields => [ map{ { name => $_, value => $additional_field_filters->{$_}} } keys %$additional_field_filters ],
 109 
            additional_fields => [ map{ { name => $_, value => $additional_field_filters->{$_}{value}, authorised_value_category => $additional_field_filters->{$_}{authorised_value_category} } } keys %$additional_field_filters ],
107 
            location     => $location,
 110 
            location     => $location,
108 
            expiration_date => $expiration_date_dt,
 111 
            expiration_date => $expiration_date_dt,
109 
        }
 112 
        }
110 
-

Return to bug 10855