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

(-)a/C4/Acquisition.pm (-4 / +22 lines)
Lines 2282-2287 sub GetHistory { Link Here
2282
    my $total_qtyreceived = 0;
2282
    my $total_qtyreceived = 0;
2283
    my $total_price       = 0;
2283
    my $total_price       = 0;
2284
2284
2285
    #get variation of isbn
2286
    my @params;
2287
    my @isbns;
2288
    if ($isbn){
2289
        if ( C4::Context->preference("SearchWithISBNVariations") ){
2290
            @isbns = C4::Koha::GetVariationsOfISBN( $isbn );
2291
            foreach my $isb (@isbns){
2292
                push @params, '?';
2293
            }
2294
        }
2295
        unless (@isbns){
2296
            push @isbns, $isbn;
2297
            push @params, '?';
2298
        }
2299
    }
2300
2285
    my $dbh   = C4::Context->dbh;
2301
    my $dbh   = C4::Context->dbh;
2286
    my $query ="
2302
    my $query ="
2287
        SELECT
2303
        SELECT
Lines 2349-2358 sub GetHistory { Link Here
2349
        push @query_params, "%$author%";
2365
        push @query_params, "%$author%";
2350
    }
2366
    }
2351
2367
2352
    if ( $isbn ) {
2368
    if ( @isbns ) {
2353
        $query .= " AND biblioitems.isbn LIKE ? ";
2369
        $query .= " AND ( biblioitems.isbn LIKE " . join (" OR biblioitems.isbn LIKE ", @params ) . ")";
2354
        push @query_params, "%$isbn%";
2370
        foreach my $isbn (@isbns){
2371
            push @query_params, "%$isbn%";
2372
        }
2355
    }
2373
    }
2374
2356
    if ( $ean ) {
2375
    if ( $ean ) {
2357
        $query .= " AND biblioitems.ean = ? ";
2376
        $query .= " AND biblioitems.ean = ? ";
2358
        push @query_params, "$ean";
2377
        push @query_params, "$ean";
2359
- 

Return to bug 17457