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

(-)a/C4/Acquisition.pm (-6 / +5 lines)
Lines 1555-1582 sub GetHistory { Link Here
1555
1555
1556
        my @query_params  = ();
1556
        my @query_params  = ();
1557
1557
1558
        if ( defined $title ) {
1558
        if ( $title ) {
1559
            $query .= " AND biblio.title LIKE ? ";
1559
            $query .= " AND biblio.title LIKE ? ";
1560
            $title =~ s/\s+/%/g;
1560
            $title =~ s/\s+/%/g;
1561
            push @query_params, "%$title%";
1561
            push @query_params, "%$title%";
1562
        }
1562
        }
1563
1563
1564
        if ( defined $author ) {
1564
        if ( $author ) {
1565
            $query .= " AND biblio.author LIKE ? ";
1565
            $query .= " AND biblio.author LIKE ? ";
1566
            push @query_params, "%$author%";
1566
            push @query_params, "%$author%";
1567
        }
1567
        }
1568
1568
1569
        if ( defined $name ) {
1569
        if ( $name ) {
1570
            $query .= " AND aqbooksellers.name LIKE ? ";
1570
            $query .= " AND aqbooksellers.name LIKE ? ";
1571
            push @query_params, "%$name%";
1571
            push @query_params, "%$name%";
1572
        }
1572
        }
1573
1573
1574
        if ( defined $from_placed_on ) {
1574
        if ( $from_placed_on ) {
1575
            $query .= " AND creationdate >= ? ";
1575
            $query .= " AND creationdate >= ? ";
1576
            push @query_params, $from_placed_on;
1576
            push @query_params, $from_placed_on;
1577
        }
1577
        }
1578
1578
1579
        if ( defined $to_placed_on ) {
1579
        if ( $to_placed_on ) {
1580
            $query .= " AND creationdate <= ? ";
1580
            $query .= " AND creationdate <= ? ";
1581
            push @query_params, $to_placed_on;
1581
            push @query_params, $to_placed_on;
1582
        }
1582
        }
1583
- 

Return to bug 7085