View | Details | Raw Unified | Return to bug 29062
Collapse All | Expand All

(-)a/C4/Letters.pm (-2 / +2 lines)
Lines 785-791 sub _parseletter_sth { Link Here
785
    ($table eq 'debits'       )    ? "SELECT * FROM accountlines WHERE   accountlines_id = ?"                         :
785
    ($table eq 'debits'       )    ? "SELECT * FROM accountlines WHERE   accountlines_id = ?"                         :
786
    ($table eq 'items'        )    ? "SELECT * FROM $table WHERE     itemnumber = ?"                                  :
786
    ($table eq 'items'        )    ? "SELECT * FROM $table WHERE     itemnumber = ?"                                  :
787
    ($table eq 'issues'       )    ? "SELECT * FROM $table WHERE     itemnumber = ?"                                  :
787
    ($table eq 'issues'       )    ? "SELECT * FROM $table WHERE     itemnumber = ?"                                  :
788
    ($table eq 'old_issues'   )    ? "SELECT * FROM $table WHERE     itemnumber = ? ORDER BY timestamp DESC LIMIT 1"  :
788
    ($table eq 'old_issues'   )    ? "SELECT * FROM $table WHERE     issue_id = ?"  :
789
    ($table eq 'reserves'     )    ? "SELECT * FROM $table WHERE borrowernumber = ? and biblionumber = ?"             :
789
    ($table eq 'reserves'     )    ? "SELECT * FROM $table WHERE borrowernumber = ? and biblionumber = ?"             :
790
    ($table eq 'borrowers'    )    ? "SELECT * FROM $table WHERE borrowernumber = ?"                                  :
790
    ($table eq 'borrowers'    )    ? "SELECT * FROM $table WHERE borrowernumber = ?"                                  :
791
    ($table eq 'branches'     )    ? "SELECT * FROM $table WHERE     branchcode = ?"                                  :
791
    ($table eq 'branches'     )    ? "SELECT * FROM $table WHERE     branchcode = ?"                                  :
Lines 1734-1740 sub _get_tt_params { Link Here
1734
            module   => 'Koha::Old::Checkouts',
1734
            module   => 'Koha::Old::Checkouts',
1735
            singular => 'old_checkout',
1735
            singular => 'old_checkout',
1736
            plural   => 'old_checkouts',
1736
            plural   => 'old_checkouts',
1737
            fk       => 'itemnumber',
1737
            pk       => 'issue_id',
1738
        },
1738
        },
1739
        overdues => {
1739
        overdues => {
1740
            module   => 'Koha::Checkouts',
1740
            module   => 'Koha::Checkouts',
(-)a/members/printslip.pl (-4 / +3 lines)
Lines 71-81 if ( $print eq 'checkinslip' ) { Link Here
71
    my $checkinslip_branch = $session->param('branch') ? $session->param('branch') : $branch;
71
    my $checkinslip_branch = $session->param('branch') ? $session->param('branch') : $branch;
72
72
73
    # get today's checkins
73
    # get today's checkins
74
    my @itemnumbers = $patron->old_checkouts->search( { branchcode => $checkinslip_branch } )
74
    my @issue_ids = $patron->old_checkouts->search( { branchcode => $checkinslip_branch } )
75
      ->filter_by_todays_checkins->get_column('itemnumber');
75
      ->filter_by_todays_checkins->get_column('issue_id');
76
76
77
    my %loops = (
77
    my %loops = (
78
        old_issues => \@itemnumbers,
78
        old_issues => \@issue_ids,
79
    );
79
    );
80
80
81
    my $letter = C4::Letters::GetPreparedLetter(
81
    my $letter = C4::Letters::GetPreparedLetter(
82
- 

Return to bug 29062