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 = ? "; |