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

(-)a/offline_circ/download.pl (-2 / +1 lines)
Lines 36-42 my $req_data = $query->param('data') || ''; Link Here
36
my $patrons_query = q{SELECT
36
my $patrons_query = q{SELECT
37
    borrowers.borrowernumber, cardnumber, surname, firstname, title,
37
    borrowers.borrowernumber, cardnumber, surname, firstname, title,
38
    othernames, initials, streetnumber, streettype, address, address2, city,
38
    othernames, initials, streetnumber, streettype, address, address2, city,
39
    state, zipcode, country, email, phone, mobile, fax, dateofbirth, branchcode,
39
    state, zipcode, country, email, phone, mobile, fax, dateofbirth, borrowers.branchcode,
40
    categorycode, dateenrolled, dateexpiry, COALESCE(gonenoaddress, 0) AS gonenoaddress,
40
    categorycode, dateenrolled, dateexpiry, COALESCE(gonenoaddress, 0) AS gonenoaddress,
41
    COALESCE(lost, 0) AS lost, debarred,
41
    COALESCE(lost, 0) AS lost, debarred,
42
    debarredcomment, SUM(accountlines.amountoutstanding) AS fine
42
    debarredcomment, SUM(accountlines.amountoutstanding) AS fine
43
- 

Return to bug 29255