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