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

(-)a/C4/Acquisition.pm (-7 / +6 lines)
Lines 1581-1613 sub GetHistory { Link Here
1581
1581
1582
    my @query_params  = ();
1582
    my @query_params  = ();
1583
1583
1584
    if ( defined $title ) {
1584
    if ( $title ) {
1585
        $query .= " AND biblio.title LIKE ? ";
1585
        $query .= " AND biblio.title LIKE ? ";
1586
        $title =~ s/\s+/%/g;
1586
        $title =~ s/\s+/%/g;
1587
        push @query_params, "%$title%";
1587
        push @query_params, "%$title%";
1588
    }
1588
    }
1589
1589
1590
    if ( defined $author ) {
1590
    if ( $author ) {
1591
        $query .= " AND biblio.author LIKE ? ";
1591
        $query .= " AND biblio.author LIKE ? ";
1592
        push @query_params, "%$author%";
1592
        push @query_params, "%$author%";
1593
    }
1593
    }
1594
1594
1595
    if ( defined $isbn ) {
1595
    if ( $isbn ) {
1596
        $query .= " AND biblioitems.isbn LIKE ? ";
1596
        $query .= " AND biblioitems.isbn LIKE ? ";
1597
        push @query_params, "%$isbn%";
1597
        push @query_params, "%$isbn%";
1598
    }
1598
    }
1599
1599
1600
    if ( defined $name ) {
1600
    if ( $name ) {
1601
        $query .= " AND aqbooksellers.name LIKE ? ";
1601
        $query .= " AND aqbooksellers.name LIKE ? ";
1602
        push @query_params, "%$name%";
1602
        push @query_params, "%$name%";
1603
    }
1603
    }
1604
1604
1605
    if ( defined $from_placed_on ) {
1605
    if ( $from_placed_on ) {
1606
        $query .= " AND creationdate >= ? ";
1606
        $query .= " AND creationdate >= ? ";
1607
        push @query_params, $from_placed_on;
1607
        push @query_params, $from_placed_on;
1608
    }
1608
    }
1609
1609
1610
    if ( defined $to_placed_on ) {
1610
    if ( $to_placed_on ) {
1611
        $query .= " AND creationdate <= ? ";
1611
        $query .= " AND creationdate <= ? ";
1612
        push @query_params, $to_placed_on;
1612
        push @query_params, $to_placed_on;
1613
    }
1613
    }
1614
- 

Return to bug 7085