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 |
- |
|
|