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