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