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 |
- |
|
|