Lines 106-112
if ($do_it) {
Link Here
|
106 |
SELECT round(amount,2) AS amount, description, |
106 |
SELECT round(amount,2) AS amount, description, |
107 |
bo.surname AS bsurname, bo.firstname AS bfirstname, m.surname AS msurname, m.firstname AS mfirstname, |
107 |
bo.surname AS bsurname, bo.firstname AS bfirstname, m.surname AS msurname, m.firstname AS mfirstname, |
108 |
bo.cardnumber, br.branchname, bo.borrowernumber, |
108 |
bo.cardnumber, br.branchname, bo.borrowernumber, |
109 |
al.borrowernumber, DATE(al.date) as date, al.credit_type_code, al.debit_type_code, al.amountoutstanding, al.note, |
109 |
al.borrowernumber, DATE(al.date) as date, al.timestamp, al.credit_type_code, al.debit_type_code, al.amountoutstanding, al.note, |
110 |
bi.title, bi.biblionumber, i.barcode, i.itype |
110 |
bi.title, bi.biblionumber, i.barcode, i.itype |
111 |
FROM accountlines al |
111 |
FROM accountlines al |
112 |
LEFT JOIN borrowers bo ON (al.borrowernumber = bo.borrowernumber) |
112 |
LEFT JOIN borrowers bo ON (al.borrowernumber = bo.borrowernumber) |
113 |
- |
|
|