Lines 99-105
if ($do_it) {
Link Here
|
99 |
SELECT round(amount,2) AS amount, description, |
99 |
SELECT round(amount,2) AS amount, description, |
100 |
bo.surname AS bsurname, bo.firstname AS bfirstname, m.surname AS msurname, m.firstname AS mfirstname, |
100 |
bo.surname AS bsurname, bo.firstname AS bfirstname, m.surname AS msurname, m.firstname AS mfirstname, |
101 |
bo.cardnumber, br.branchname, bo.borrowernumber, |
101 |
bo.cardnumber, br.branchname, bo.borrowernumber, |
102 |
al.borrowernumber, DATE(al.date) as date, al.credit_type_code, al.debit_type_code, al.amountoutstanding, al.note, |
102 |
al.borrowernumber, DATE(al.date) as date, al.credit_type_code, al.debit_type_code, |
|
|
103 |
al.payment_type, al.amountoutstanding, al.note, |
103 |
bi.title, bi.biblionumber, i.barcode, i.itype |
104 |
bi.title, bi.biblionumber, i.barcode, i.itype |
104 |
FROM accountlines al |
105 |
FROM accountlines al |
105 |
LEFT JOIN borrowers bo ON (al.borrowernumber = bo.borrowernumber) |
106 |
LEFT JOIN borrowers bo ON (al.borrowernumber = bo.borrowernumber) |
Lines 160-165
if ($do_it) {
Link Here
|
160 |
$row->{date}, |
161 |
$row->{date}, |
161 |
$row->{credit_type}, |
162 |
$row->{credit_type}, |
162 |
$row->{debit_type}, |
163 |
$row->{debit_type}, |
|
|
164 |
$row->{payment_type}, |
163 |
$row->{note}, |
165 |
$row->{note}, |
164 |
$row->{amount}, |
166 |
$row->{amount}, |
165 |
$row->{title}, |
167 |
$row->{title}, |
166 |
- |
|
|