|
Lines 1960-1966
sub GetItemIssue {
Link Here
|
| 1960 |
my ($itemnumber) = @_; |
1960 |
my ($itemnumber) = @_; |
| 1961 |
return unless $itemnumber; |
1961 |
return unless $itemnumber; |
| 1962 |
my $sth = C4::Context->dbh->prepare( |
1962 |
my $sth = C4::Context->dbh->prepare( |
| 1963 |
"SELECT * |
1963 |
"SELECT *,issues.renewals AS renewals,items.renewals AS totalrenewals |
| 1964 |
FROM issues |
1964 |
FROM issues |
| 1965 |
LEFT JOIN items ON issues.itemnumber=items.itemnumber |
1965 |
LEFT JOIN items ON issues.itemnumber=items.itemnumber |
| 1966 |
WHERE issues.itemnumber=?"); |
1966 |
WHERE issues.itemnumber=?"); |
|
Lines 2011-2023
sub GetItemIssues {
Link Here
|
| 2011 |
my ( $itemnumber, $history ) = @_; |
2011 |
my ( $itemnumber, $history ) = @_; |
| 2012 |
|
2012 |
|
| 2013 |
my $today = C4::Dates->today('iso'); # get today date |
2013 |
my $today = C4::Dates->today('iso'); # get today date |
| 2014 |
my $sql = "SELECT * FROM issues |
2014 |
my $sql = "SELECT *,issues.renewals AS renewals,items.renewals AS totalrenewals |
|
|
2015 |
FROM issues |
| 2015 |
JOIN borrowers USING (borrowernumber) |
2016 |
JOIN borrowers USING (borrowernumber) |
| 2016 |
JOIN items USING (itemnumber) |
2017 |
JOIN items USING (itemnumber) |
| 2017 |
WHERE issues.itemnumber = ? "; |
2018 |
WHERE issues.itemnumber = ? "; |
| 2018 |
if ($history) { |
2019 |
if ($history) { |
| 2019 |
$sql .= "UNION ALL |
2020 |
$sql .= "UNION ALL |
| 2020 |
SELECT * FROM old_issues |
2021 |
SELECT *,old_issues.renewals AS renewals,items.renewals AS totalrenewals |
|
|
2022 |
FROM old_issues |
| 2021 |
LEFT JOIN borrowers USING (borrowernumber) |
2023 |
LEFT JOIN borrowers USING (borrowernumber) |
| 2022 |
JOIN items USING (itemnumber) |
2024 |
JOIN items USING (itemnumber) |
| 2023 |
WHERE old_issues.itemnumber = ? "; |
2025 |
WHERE old_issues.itemnumber = ? "; |