@@ -, +, @@ letters --- C4/Letters.pm | 4 ++-- members/printslip.pl | 6 +++--- 2 files changed, 5 insertions(+), 5 deletions(-) --- a/C4/Letters.pm +++ a/C4/Letters.pm @@ -785,7 +785,7 @@ sub _parseletter_sth { ($table eq 'debits' ) ? "SELECT * FROM accountlines WHERE accountlines_id = ?" : ($table eq 'items' ) ? "SELECT * FROM $table WHERE itemnumber = ?" : ($table eq 'issues' ) ? "SELECT * FROM $table WHERE itemnumber = ?" : - ($table eq 'old_issues' ) ? "SELECT * FROM $table WHERE itemnumber = ? ORDER BY timestamp DESC LIMIT 1" : + ($table eq 'old_issues' ) ? "SELECT * FROM $table WHERE issue_id = ?" : ($table eq 'reserves' ) ? "SELECT * FROM $table WHERE borrowernumber = ? and biblionumber = ?" : ($table eq 'borrowers' ) ? "SELECT * FROM $table WHERE borrowernumber = ?" : ($table eq 'branches' ) ? "SELECT * FROM $table WHERE branchcode = ?" : @@ -1757,7 +1757,7 @@ sub _get_tt_params { module => 'Koha::Old::Checkouts', singular => 'old_checkout', plural => 'old_checkouts', - fk => 'itemnumber', + pk => 'issue_id', }, overdues => { module => 'Koha::Checkouts', --- a/members/printslip.pl +++ a/members/printslip.pl @@ -71,11 +71,11 @@ if ( $print eq 'checkinslip' ) { my $checkinslip_branch = $session->param('branch') ? $session->param('branch') : $branch; # get today's checkins - my @itemnumbers = $patron->old_checkouts->search( { branchcode => $checkinslip_branch } ) - ->filter_by_todays_checkins->get_column('itemnumber'); + my @issue_ids = $patron->old_checkouts->search( { branchcode => $checkinslip_branch } ) + ->filter_by_todays_checkins->get_column('issue_id'); my %loops = ( - old_issues => \@itemnumbers, + old_issues => \@issue_ids, ); my $letter = C4::Letters::GetPreparedLetter( --